Archives of the TeradataForum

Message Posted: Fri, 15 May 2009 @ 09:48:00 GMT

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

Do you mean that the join order in the explain plan does not match the order in which the joins were written in your query? This is probably not a problem -- although it's difficult to say for sure since you have not included the full explain text.

The optimizer's job is to determine the most efficient way to answer the query that was submitted. Sometimes this means changing the join order, because it is more efficient.

Regards,

Jason Swartzbaugh
Sr. Benchmark Analyst
Teradata Corporation

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