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
3161
October 26, 2013 11:38AM
1161
October 28, 2013 08:56AM
Re: Simple query seems to be ignoring date index
1074
October 28, 2013 09:35PM
1083
October 29, 2013 10:19AM
1191
October 30, 2013 07:47PM
1148
October 31, 2013 12:23AM
1113
November 01, 2013 02:47AM
1193
November 01, 2013 11:20AM
1374
November 01, 2013 10:45PM
1105
November 02, 2013 09:45PM
1163
November 02, 2013 09:59PM
1202
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.