
Why Are Reverse Index Scans Slower in InnoDB?
InnoDB's ORDER BY DESC is slower than ASC due to its unidirectional linked list design, making reverse scans O(n) versus forward scans O(1).
Rebooter.S
Read More
6 min

InnoDB's ORDER BY DESC is slower than ASC due to its unidirectional linked list design, making reverse scans O(n) versus forward scans O(1).