Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2005 @ 19:11:57 GMT

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

<-- Anonymously Posted: Wednesday, August 03, 2005 13:34 -->

Subquery is not straight away identified in the explain. You should go by the tables and conditions in the subquery and see how it is being processed by the optimizer. Optimizer tries different ways of processing a subquery depending on the subquery conditions.

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