go-mysql-server icon indicating copy to clipboard operation
go-mysql-server copied to clipboard

Published 20 hours ago • verified publisher icon dolthub

Use indexes when applicable to `ORDER BY`

Open Hydrocharged opened this issue 2 years ago • 2 comments

We don't currently support using indexes with ORDER BY. https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html

Hydrocharged avatar Jan 24 '23 15:01 Hydrocharged

A user ran into a performance limitation due to this missing functionality: https://github.com/dolthub/dolt/issues/5175

Hydrocharged avatar Jan 24 '23 15:01 Hydrocharged

From my prospective, fixed in dolthub/dolt-sql-server:1.31.1

nkonev avatar Jan 12 '24 03:01 nkonev