Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2001 @ 12:33:39 GMT


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


Subj:   Re: Performance optimization issue
 
From:   Barbara George

Sauli

For an index on the date to be used the dates must be specified explicitly, that is not using between or > .

For a few dates that can be dynamically calculated I use the following :

... (tran_date = date or tran_date = date-1 or tran_date = date-2) ...

This uses an index, whereas ... tran_date between date-2 and date ... will perform a full-table scan.

Barbara George
Business Information Manager
Pick 'n Pay, Cape Town, South Africa



     
  <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