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?!
Subject
Views
Written By
Posted
4407
January 02, 2007 09:24AM
2212
January 02, 2007 08:11PM
Re: Two general MySQL questions
2185
January 03, 2007 05:35PM
2193
January 03, 2007 06:10PM
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.