Indexing for date column for range query
Posted by:
duc minh
Date: July 05, 2016 11:04PM
I have a table which includes 'insert_date' column and 'update_date' column.
And I want to find all record satisfy conditions: input date > 'insert_date' and input date < 'update_date'.
What should I index for this table ? And what query should I use ?
What solution is the best for performance ?
Subject
Views
Written By
Posted
Indexing for date column for range query
1235
July 05, 2016 11:04PM
729
July 09, 2016 10:47PM
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.