MySQL Forums
Forum List  »  Performance

Re: Simple query seems to be ignoring date index
Posted by: Rick James
Date: November 02, 2013 09:59PM

If this is the most common query:
SELECT * FROM test WHERE Date='2008-10-1';
You need some INDEX _starting_ with Date.

PRIMARY KEY(Sym, Date), INDEX(Date)
or
PRIMARY KEY(Date, Sym), INDEX(Sym)

Either of those would provide the UNIQUEness constraint (the PRIMARY KEY). In MyISAM, either would make the allow that SELECT to be somewhat efficient. It will be even more efficient if the data is INSERTed in Date order. If you get new data each day, than that is the order of insertion.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Simple query seems to be ignoring date index
1041
November 02, 2013 09:59PM


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.