MySQL Forums
Forum List  »  Optimizer & Parser

Re: Two general MySQL questions
Posted by: Joost
Date: January 04, 2007 05:49AM

A. I meant :) the following:
Because each result from table1 is JOINed the amount of results (filtered by the WHERE clause) coming from table1 should be as small as possible. So this should be the table of which the amount of results is 'limited' the most by the where clause.. (not sure if this makes it any clearer :))

C. table2 should have a good index (with the join key in it???)
> You definitely need this one, to have an index on the join column of the 2nd table > to perform the join efficiently.

Does the order of the index makes any difference? Should I put in the join column first or last?

Options: ReplyQuote


Subject
Views
Written By
Posted
4408
January 02, 2007 09:24AM
2212
January 02, 2007 08:11PM
2186
January 03, 2007 05:35PM
2194
January 03, 2007 06:10PM
Re: Two general MySQL questions
2182
January 04, 2007 05:49AM
2220
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.