Archives of the TeradataForum

Message Posted: Mon, 12 Feb 2007 @ 14:41:26 GMT

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

I don't know how to make your query efficient in general but if you could try the syntax discussed in the similar thread:

www.teradataforum.com/teradata/20040203_183729.htm .

By the way, on recent releases we may try and use different syntax forms hoping to achieve certain goals but there is no guarantee that the query will not be rewritten by the optimizer before it is actually executed so you should probably go for more robust methods of performance optimization.

Regards,

Victor

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