MySQL Forums
Forum List  »  Optimizer & Parser

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 ?

Options: ReplyQuote

Written By
Indexing for date column for range query
July 05, 2016 11:04PM

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.