How do I add an index to a column that is datetime?

Possible Duplicate

How does one create an index on the date part of DATETIME field in MySql

开发者_StackOverflow

In mysql. It's a date column

---

You do it in the same way as you would for any other column type:

CREATE INDEX IX_tblname_columnname
ON tbl_name (columnname)

See the documentation for more information and other options.