Archives of the TeradataForum
Message Posted: Mon, 29 Oct 2001 @ 08:28:54 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|