Can I create a index on a column of Type datetime?

[wangxu]

I will very often do query like this:

select * from mytable where create_date >='...' and create_date <='....'

can I create a index on the column create_date?

what is the best practise?

Thanks,
shell.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]