Archives of the TeradataForum
Message Posted: Thu, 28 Aug 2003 @ 13:27:41 GMT
| Subj: | | Join Order In Teradata |
| |
| From: | | Dave Harper |
Greetings All:
I had a general question regarding how/why Teradata is join order specific. I hadn't been aware that table ordering in my join condition
would have an impact on the query plan that is generated -- I know it isn't like that in SQL Server and I believe Oracle. Is this done for
MPP so that each spool can be merged more easily dependant upon the data it retrieves?
Is there a way to determine the best 'order' to join tables? Or is it more trial and error?
Thanks in advance.
Dave Harper
| 
