MySQL Forums
Forum List  »  Optimizer & Parser

Re: Two general MySQL questions
Posted by: Joost
Date: January 03, 2007 05:35PM

Thanks KimSeong Loh,

So the best way to create a join query (eg. select x from table1 join table2) is to:
A. table1 should have the least amount of (expected) results
B. table1 should be have a good index
C. table2 should have a good index (with the join key in it???)

Am I right?!

Options: ReplyQuote


Subject
Views
Written By
Posted
4442
January 02, 2007 09:24AM
2232
January 02, 2007 08:11PM
Re: Two general MySQL questions
2208
January 03, 2007 05:35PM
2218
January 03, 2007 06:10PM
2211
January 04, 2007 05:49AM
2241
January 04, 2007 10:53AM


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.