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
4465
January 02, 2007 09:24AM
2244
January 02, 2007 08:11PM
Re: Two general MySQL questions
2226
January 03, 2007 05:35PM
2229
January 03, 2007 06:10PM
2219
January 04, 2007 05:49AM
2256
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.