How to add index to datetime column?

Question

Possible Duplicate
How to create an index on the date part of the DATETIME field in MySql

In mysql. This is a date column.

Answer 1

You do this the same way as for any other type of column:

CREATE INDEX IX_tblname_columnname
ON tbl_name (columnname)

See the documentation for more information and other parameters.