Archives of the TeradataForum

Message Posted: Fri, 15 May 2009 @ 09:51:01 GMT

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

Teradata does not process joins in the order which they are written. Teradata leverages a cost based optimizer and other enhancements such as query rewrite and join elimination when trying to determine the least expensive plan for the query that was submitted. The optimizer will take into consideration the primary indexes, secondary indexes, statistics, and random amp sampling of the tables involved.

It would be helpful to understand the underlying table structures, primary indexes, and statistics involved in the query as well as the entire join conditions.

Hope this helps.

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