MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Execution ordering for multiple join operations
Posted by: Joerg Neidig
Date: October 18, 2005 01:04AM

Hi,

I frequently have to natural join ten or more tables. Thereby the order in which the tables are joined is extremely important when considering the size of the intermediate results.
Do you know any existing procedures to optimize the ordering in which the tables are joined? Is there a build-in feature in MySQL or do I need to write some own code?

Thanks,

Jörg Neidig

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Execution ordering for multiple join operations
2043
Joerg Neidig
October 18, 2005 01:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.