Re: Trying to avoid "Using filesort"
In that case is there any way I can tell it to read table a first?
Just seems odd that adding a left join to a query (one that the optimizer shouldn't have to deal with until it knows which rows it needs) forces a filesort.
Any way I can index or hint to prevent this please?
Subject
Views
Written By
Posted
2540
June 22, 2008 02:57PM
1539
June 22, 2008 06:25PM
Re: Trying to avoid "Using filesort"
1736
June 23, 2008 12:04AM
1587
June 24, 2008 03:03AM
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.