MySQL Forums
Forum List  »  Performance

Re: subquery vs. join?
Posted by: James Day
Date: January 21, 2005 11:38PM

Hector Vass gave one possibly helpful approach: use a temporary table to use one index and get the initial filtering of the big data set, then use that temporary table to complete the query. I've seen very large performance gains from this approach. In addition to the use of the index, the filtered table subset is more likely to fit in cache.

Options: ReplyQuote


Subject
Views
Written By
Posted
20450
December 03, 2004 02:52AM
7142
December 05, 2004 03:03AM
5957
December 05, 2004 07:52PM
6166
January 20, 2005 03:48AM
5309
January 20, 2005 06:52AM
4677
January 21, 2005 11:43PM
Re: subquery vs. join?
4871
January 21, 2005 11:38PM
3890
January 20, 2005 04:41PM


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.