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
2905
October 26, 2013 11:38AM
1050
October 28, 2013 08:56AM
Re: Simple query seems to be ignoring date index
978
October 28, 2013 09:35PM
988
October 29, 2013 10:19AM
1078
October 30, 2013 07:47PM
1043
October 31, 2013 12:23AM
1005
November 01, 2013 02:47AM
1066
November 01, 2013 11:20AM
1255
November 01, 2013 10:45PM
1002
November 02, 2013 09:45PM
1056
November 02, 2013 09:59PM
1028
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.