[SQL] Do I need to add an Index on ORDER BY field?

I have a query of such like

$query = "SELECT * FROM tbl_comments WHERE id=222 ORDER BY comment_time";


Do I need to add an index on the comment_time field?

Also, if I want to get the data between two dates then how should I build the index?

Continue reading...