Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020