Re: GROUP causing Using Temporary Using Filesort
A covering index should work, did you try a summary index like (testid,runid,accountid,lastupdate,resultcode)?
Subject
Views
Written By
Posted
24590
July 31, 2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort
6983
July 31, 2014 03:24PM
5434
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.