Is searching faster if indexed values are the same?
Indexes perform better when they have unique values like customer ID, acc number etc. The more unique your indexed field is the less number of records gets picked improving the performance. You can build index on the date field, but would that be unique enough to filter the record you need?