Archives of the TeradataForum

Message Posted: Wed, 20 May 2009 @ 15:57:34 GMT

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

Chaithanya:

The only explanation is that you wrote your SQL join incorrectly. The optimizer is fixing the plan to be efficient, unlike your SQL which joins tablea first.

It might be that the PIs of tablec and tabled are used in the join. Otherwise, they may be the smallest tables. Regardless of the reason, you did not write optimal SQL so the optimizer is doing the job correctly for you. You can be happy about this capability.

Regards,

Certified Teradata Master
Certified Teradata SQL Instructor

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