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.
Subject
Views
Written By
Posted
2885
October 26, 2013 11:38AM
1042
October 28, 2013 08:56AM
969
October 28, 2013 09:35PM
983
October 29, 2013 10:19AM
1068
October 30, 2013 07:47PM
1033
October 31, 2013 12:23AM
999
November 01, 2013 02:47AM
1060
November 01, 2013 11:20AM
1246
November 01, 2013 10:45PM
992
November 02, 2013 09:45PM
Re: Simple query seems to be ignoring date index
1041
November 02, 2013 09:59PM
1018
November 04, 2013 04:55AM
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.