MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Need to optimise complex query
3193
Ben Sebborn
April 29, 2007 04:13PM
Re: Need to optimise complex query
1987
KimSeong Loh
April 29, 2007 10:21PM
Re: Need to optimise complex query
2050
Ben Sebborn
April 30, 2007 05:00AM
Re: Need to optimise complex query
2107
KimSeong Loh
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.