Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Sep 2003 @ 18:42:11 GMT


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


Subj:   NUSI is good for range conditions
 
From:   Rick Davis

All,

Range predicates (like,>,<,>=,<=) will use NUSI's ?

For example I have a table with 10 columns , Col1 is UPI

SEL  * FROM
WHERE col2 = 'string'  AND
          col3 = 'rick' AND
          col4 = 12345
          col5 > 0

creating a NUSI on col2,3,4 is good or NUSI on col2,3 is good ?

Rick



     
  <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