Tag: Index Scans

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).