Archives of the TeradataForum

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

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

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>>