Does reordering table rows reduce the time for subsequent ordering with the ORDER BY clause?

0 votes

2 answers

174 views

mysql performance select order-by benchmark

                          Is there any run-time advantage gained by changing the order of a table's rows to match the expected ordering of the ORDER BY that is in a slow select?

(assuming unique alphanumeric index and no auto-increments if these matter)

Asked by beppe9000 (101 rep)

Jan 31, 2020, 06:54 PM
Last activity: Jul 7, 2025, 10:02 PM

Does reordering table rows reduce the time for subsequent ordering with the ORDER BY clause?

Related Questions