1" as that's far to big for my little test demo database and I would have expected it to be too large for your system too." />
 
Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Feb 2008 @ 23:55:10 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Freq of index usage
 
From:   Street, John

Hi,

I just tried your code with "I" as being the comparison value and it works fine for me.

I had to get rid of the "And current_perm / (2**30) > 1" as that's far to big for my little test demo database and I would have expected it to be too large for your system too.

Are you sure you are capturing DBQL correctly and there are 'I' rows in the DBQL obj table?


Cheers

John Street

Senior Solution Architect
Teradata Certified Master



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016