Re: Simple query seems to be ignoring date index
Posted by:
Rick James
Date: October 28, 2013 09:35PM
You have made a lot of changes. Please summarize them by providing
SHOW CREATE TABLE
EXPLAIN
Then we might be able to address your questions.
None of the fields need to be NULLable, do they? Suggest you make them NOT NULL.
The EXPLAIN for these will be quite different:
SELECT mdate from test where mdate=20081020;
SELECT * from test where mdate=20081020;
Please use the desired statements when EXPLAINing them.
Subject
Views
Written By
Posted
2886
October 26, 2013 11:38AM
1042
October 28, 2013 08:56AM
Re: Simple query seems to be ignoring date index
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
1061
November 01, 2013 11:20AM
1246
November 01, 2013 10:45PM
992
November 02, 2013 09:45PM
1042
November 02, 2013 09:59PM
1019
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.