Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jan 2004 @ 18:12:04 GMT


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


Subj:   Re: V2R5 Statistics
 
From:   Victor Sokovin

Narayan,

  So which is efficient and performant.  


  Suppose I had 2 where clauses as follows :  


  1. WHERE col1 = 1 and col2 = 2  


  2. WHERE (col1,col2) = (1,2)  


  In the above case which kind of statistics would/should be used.  



In my opinion, these two syntax forms are optimized in exactly the same way. If there are any differences or bugs in some releases perhaps somebody from NCR could correct me. I personally practically never use the second (vector) form as it never occurred to me that it might offer any additional advantages in performance.

In both cases the multi-column statistics on (col1, col2) should be the most efficient form of statistics. A special case is when there is an SI defined on one of the columns. In that case additional index statistics might also be useful for the optimizer.


Regards,

Victor



     
  <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: 15 Jun 2023