Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Nov 2006 @ 21:24:44 GMT


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


Subj:   Value Ordered NUSI & Regular NUSI on Same Column?
 
From:   Stover, Terry

We're experimenting adding value ordered nusi's to some of our frequently accessed date columns and most of these columns already have regular nusi's defined. The goal is to speed up the queries using date ranges that are currently doing full table scans. I haven't found any guidance in the various NCR manuals, does anyone have experience using both hash and value ordered nusi's on the same columns?.



     
  <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