Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2001 @ 08:56:11 GMT


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


Subj:   Re: Secondary Indexes
 
From:   Howard Bradley

Dave

thanks for the further info . I have decided , at this time , not to add the extra SI's .

It is possible (although a bit messy) to get the desired results for a given week number and still use the existing SI's on the DATE columns by specifying the week number and a date range (of say 8 days) which is known to cover all (and a bit more) or the desired week . If this proves too complex a concept for our users (that is not supposed to sound derogatory - well not too derogatory) I may have to re think the approach or limit their expectation on query times and accept a full table scan .


Thanks again for the help .

Howard .



     
  <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