MySQL Forums
Forum List  »  Newbie

Re: Index not being used
Posted by: Rick James
Date: November 18, 2009 05:06PM

Given...
WHERE sample_time > '2009-10-28 00:00:00' and location_ID = -1 AND anomaly_Detected = 0

Start with the "=" fields, not the range (>):
INDEX(`Location_ID`,`Anomaly_Detected`, `Sample_Time`)

What you had would have stopped looking at the index after sample_time.

Options: ReplyQuote


Subject
Written By
Posted
November 16, 2009 09:20AM
November 18, 2009 05:21AM
November 18, 2009 10:48AM
Re: Index not being used
November 18, 2009 05:06PM
November 19, 2009 03:09PM
November 19, 2009 05:13PM
November 19, 2009 07:30PM
November 19, 2009 09:35PM
November 20, 2009 08:36AM
November 20, 2009 07:28PM
November 23, 2009 09:21AM
November 23, 2009 10:23AM


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.