Archives of the TeradataForum
Message Posted: Thu, 28 Aug 2003 @ 13:27:41 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|