Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 Mar 2003 @ 20:59:38 GMT


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


Subj:   Teradata sql and range value queries
 
From:   Raj Basu

Hi ,

we are starting to implement a Teradata datawarehosue here and have run into a few issues with the sql.

1) there seems to be no index support for range value queries. Like, x>10 and x<15 or x between 10 and 15. The moment you use >< operator , you loose the index. I guess the hash indexing schema is unable to support this, while a b-tree index would have been able to. Have any of you been able to find a workaround for this? or are we destined to full table scans the moment we submit an inequality query.

2) subquery's seem to support the ansi-99 standard syntax, but underneath, just join the the nested and outside tables together on the common column...instead of running the outside query once for each value returned by the subquery query. Is there a workaround for this too?



     
  <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