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 MARCH 06, 2024

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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.