Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Feb 2002 @ 12:11:21 GMT


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


Subj:   Re: optimiser query
 
From:   Ulrich Arndt

I made the same experience in the past:

Logical equal but different written SQLs (where clause vs. inner join syntax) can result in different plans and usually one is much better (not always the where clause).

NCR says always the optimiser does query rewriting but in this area it seems to have some lacks.

Will this change in a future release?


Regards,

Ulrich



     
  <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: 15 Jun 2023