Archives of the TeradataForum
Message Posted: Mon, 16 Sep 2002 @ 19:57:21 GMT
| Subj: || || Re: optimiser query |
| From: || || Kumaran Anantaraman |
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.