Index on timestamp

[Adeline M]

Hi

Is it a good idea to put an index in a timestamp column (created_at) ?

The table contains millions of rows and it will grow every minutes (~150K more rows per day)

This is my table ouv :

+---------------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| c_id | int(11) | NO | | NULL | |
| d_id | int(11) | NO | | NULL | |
| created_at | timestamp | NO | | 0000-00-00 00:00:00 | |
| updated_at | timestamp | NO | | 0000-00-00 00:00:00 | |
+---------------------+------------------+------+-----+---------------------+----------------+

My query is like :
SELECT d_id from ouv where created_at > '2016-07-13 00:00:00' and created_at < '2016-10-13 00:00:00'