Re: Avoiding "Using temporary; Using filesort"
Posted by:
Irfan Ali
Date: July 17, 2011 04:01AM
As long as i know,
"MySQL not uses more than one index per table"
For this particular id index already used from publications table and MySQL can't utilize date key from same table.
It uses primary key id column from publications to join with publication_credits on publication_id column. And author_id from publication_credits table.
The best way to use same key for GROUP BY & ORDER BY clauses which used for filtering records in WHERE clause.
Subject
Views
Written By
Posted
4794
July 15, 2011 07:34AM
1592
July 15, 2011 07:45AM
Re: Avoiding "Using temporary; Using filesort"
1507
July 17, 2011 04:01AM
1554
July 17, 2011 09:45PM
1798
July 18, 2011 12:35PM
1916
July 18, 2011 08:08PM
1877
July 20, 2011 07:27AM
1261
July 26, 2011 02:35AM
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.