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
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.