MySQL Forums
Forum List  »  Newbie

Re: Query ignoring a condition in the "where" clause
Posted by: Rick James
Date: May 23, 2016 04:01PM

I consider it a big mistake to "normalize" datetime or any other "continuous" value.

What other queries will you have?

DATETIME is 5 bytes; INT is 4 bytes. That's not much savings is space. And it is a huge loss in performance when you need to search by a range of date/time.

Options: ReplyQuote


Subject
Written By
Posted
Re: Query ignoring a condition in the "where" clause
May 23, 2016 04:01PM


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.