CODEWITHSUNDEEP
mysql
Fehu
Fehu

Reputation: 381

It make sense to index a datetime field?

I have a table approaching the billions of records and with various indexed fields, one of which is a datetime that I use only for selecting records between two dates, and never for a join.

Does it make sense or is it possible to de-index it?

Upvotes: 0

Views: 571

Answers (1)

SE1986
SE1986

Reputation: 2750

On the face of it, it seems a good idea if it is used in a WHERE clause.

The way to find out if it would benefit would be to view the execution plan of one the queries before and after adding it and see if it has made a difference.

An index may still be ignored if the query is returning a large amount of rows in the index as it would more efficient in that case to do am index scan rather than an index seek

Upvotes: 2

Related Questions