MySQL Forums
Forum List  »  Performance

Re: Using Filesort and Using Temporary
Posted by: Lee Evanochko
Date: July 31, 2006 08:12AM

Thank you for a reply,

So when using distinct there is no way to optimize further?

Is there a way to force table order?

If I changed the distinct to group by would optimization be possible?

Can you reccomend some alteration to the sql statements to allow for optimizations?



Edited 2 time(s). Last edit at 07/31/2006 03:27PM by Lee Evanochko.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using Filesort and Using Temporary
5505
July 31, 2006 08:12AM


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.