

Archives of the TeradataForum
Message Posted: Tue, 20 Jan 2004 @ 18:12:04 GMT
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 multicolumn 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
 