Re: query not using index
Posted by:
gigi kent
Date: November 04, 2013 05:39AM
Hmm, I understand there would be no way for mysql to use the third column (time) in order to get rid of "Using filesort" but shouldn't it use the former (lat, lon) columns to satisfy the where condition ?
If I take out the "ORDER BY time" part then it starts using the index.
Subject
Written By
Posted
November 02, 2013 02:58PM
November 03, 2013 12:43PM
Re: query not using index
November 04, 2013 05:39AM
November 05, 2013 09:53PM
November 08, 2013 09:42AM
November 09, 2013 03:42PM
November 12, 2013 09:54PM
November 13, 2013 06:31PM
November 13, 2013 08:56PM
November 18, 2013 12:20AM
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.