Re: Using Filesort and Using Temporary
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.
Subject
Views
Written By
Posted
11965
July 27, 2006 07:53AM
5353
July 31, 2006 07:37AM
5909
July 31, 2006 07:45AM
Re: Using Filesort and Using Temporary
5505
July 31, 2006 08:12AM
5114
August 16, 2006 01:54PM
6265
August 15, 2006 04:58PM
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.