Possible Duplicate
http://stackoverflow.com/questions/95183/how-does-one-create-an-index-on-the-date-part-of-datetime-field-in-mysql
In mysql. It's a date column
views:
42answers:
1
+2
A:
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.
Mark Byers
2010-04-02 21:24:09
If I create this index on my master, will it get replicated over to my slave?
TIMEX
2010-04-02 21:27:58
@alex: I have no idea, but you can check by running `SHOW CREATE TABLE tblname` on your slave and see if the index is present or not.
Mark Byers
2010-04-02 21:43:46