Archives of the TeradataForum
Message Posted: Thu, 02 Mar 2006 @ 15:02:40 GMT
| Subj: | | Re: Table and join sequences.. |
| |
| From: | | Dempsey, Mike |
The simple answer is "you don't".
Teradata's optimizer will determine the join order - it pretty much ignores the order you specify.
What you do want to do is ensure that you have collected statistics on the join columns so that the optimizer has good numbers to work with.
(This is especially true if the data is not well distributed across the AMPs.)
Mike Dempsey
Teradata Client Tools
| 
