Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Dec 2009 @ 15:20:37 GMT


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


Subj:   Theoretical collection over collecting stats
 
From:   Mohd Suhail

Hello All,

Suppose i have a query in the following format:

     select * from tbl
     where col1='value'

The column: col1 is not part of any index in the table: tbl. There are no stats collected on the column: col1

Since the column: col1 is not part of any index, the above query will be an ALL-AMP operation. In other words a full table scan. So my question is:

Theoretically how will collecting stats on this column help? What will be performed differently by the optimizer after collecting stats to make the data retreival quick?

Thanks in advance for your suggestions.



     
  <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