Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 19:57:21 GMT

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

I am currently facing same issue : 2 queries that are only different in the order of the table names in the FROM clause produce different plans, in fact 1 has a product join of 1=1. Subject to the explanation given above by Hough, is there a guideline on preferred order of table? Is it better to list small tables first, or good selectivity tables first? I am also going to explore collect stats to help optimizer break the tie.

Thanks.

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