Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 Mar 2003 @ 22:13:33 GMT


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


Subj:   Re: Teradata sql and range value queries
 
From:   Kohut, Eric J

In addition,

For #1, If you force the join to a reference table and do the range condition on the reference table, these will be resolved during the scan of the reference table and the values used to restrict any larger table via a normal Secondary or Primary Index.


God Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <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