Re: Query ignoring a condition in the "where" clause
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.
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.