Alex Rivera | Logout

Order by column should have index or not?

Asked 2012-01-20T07:26:06.127
29

I am adding indexes to table with millions of records which is used for searching results. I am showing results in ASC or DESC order. My question is should that column have an index or not? I have 2 more indexes on that table. How will performance be affected by adding or not adding an index to that column?

mysql sql performance indexing sql-order-by
Edit
Report

1 Answer

27

Order by columns are used for ordering the result set, not filtering. An index on the columns mentioned in the order by clause is unlikely to change anything, especially if it's not used to filter the data.

answered 2012-01-20T07:35:53.933

Your Answer