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
3167
October 26, 2013 11:38AM
1163
October 28, 2013 08:56AM
Re: Simple query seems to be ignoring date index
1077
October 28, 2013 09:35PM
1085
October 29, 2013 10:19AM
1192
October 30, 2013 07:47PM
1149
October 31, 2013 12:23AM
1114
November 01, 2013 02:47AM
1197
November 01, 2013 11:20AM
1376
November 01, 2013 10:45PM
1107
November 02, 2013 09:45PM
1165
November 02, 2013 09:59PM
1203
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.