Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Oct 2001 @ 08:28:54 GMT


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


Subj:   Re: Execution Plans for ANSI vs non_ANSI formatted SQL
 
From:   Paul Johnson

The optimiser will often throw out surprising explain reports when the 'same' query is written using slightly different techniques, such as ANSI join v 'old style' join. Not only that, but the performance implications can be quite severe.

Only the folks at NCR are likely to be able to explain away this apparent anomaly...or maybe not?

The only way to be sure that the query is going to run in an efficient manner is to always examine the explain report before moving a new piece of code into production.

Paul Johnson.



     
  <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