Re: GROUP causing Using Temporary Using Filesort
Posted by:
RT Lee
Date: July 31, 2014 05:45PM
Thank you Peter. I AccountID column you list in the suggested index is not in the detail table - it is only in the summary table. Is there some way to create a cross table index or something? Maybe I am not understanding something in your post? Thank you again. I am very appreciative for your help.
Subject
Views
Written By
Posted
24590
July 31, 2014 02:35PM
6983
July 31, 2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort
5433
July 31, 2014 05:45PM
4844
August 01, 2014 04:45PM
3442
August 01, 2014 08:26PM
3032
August 01, 2014 11:45PM
2856
August 02, 2014 08:23AM
3101
August 02, 2014 12:44PM
2009
October 30, 2014 12:57PM
1467
October 31, 2014 11:15AM
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.