Performance of SQL Command with LIMIT Clause and Index on ORDER BY Clause when Many Rows Match Conditions from WHERE Clause
(Doc ID 1934754.1)
Last updated on FEBRUARY 27, 2020
Applies to:MySQL Server - Version 5.0 and later
Information in this document applies to any platform.
- SQL command with ORDER BY and LIMIT clauses (sometimes) shows long execution times.
- Explain output shows big number in "row" column the query when LIMIT and ORDER BY parts are commented out.
- Index exist for ORDER BY condition.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document