MySQL Forums
Forum List  »  Optimizer & Parser

Re: Need to optimise complex query
Posted by: KimSeong Loh
Date: April 29, 2007 10:21PM

Using temporary and using filesort, try to determine if these can be done in memory without storing the temp file on disk or using the the disk to do merge sort.

Options: ReplyQuote


Subject
Views
Written By
Posted
3188
April 29, 2007 04:13PM
Re: Need to optimise complex query
1985
April 29, 2007 10:21PM
2047
April 30, 2007 05:00AM
2102
April 30, 2007 08:36PM


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.