MySQL Forums
Forum List  »  Performance

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Simple query seems to be ignoring date index
969
October 28, 2013 09:35PM


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.