filesort with small LIMIT optimization

You are viewing an old version of this article. View the current version here.

MySQL 5.6 has an optimization for filesort with small LIMIT. MariaDB

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ Query Optimizations ↑
Index Hints: How to Force Query Plans
Subquery Optimizations
Optimization Strategies
Optimizations for Derived Tables
Table Elimination
Statistics for Optimizing Queries
Filesort with Small LIMIT Optimization
LIMIT ROWS EXAMINED
index_merge sort_intersection
MariaDB 5.3 Optimizer Debugging
optimizer_switch
How to Quickly Insert Data Into MariaDB
Index Condition Pushdown
Query Limits and Timeouts
Aborting Statements that Exceed a Certain Time to Execute
Partition Pruning and Selection
Big DELETEs
Charset Narrowing Optimization
Data Sampling: Techniques for Efficiently Finding a Random Row
Data Warehousing High Speed Ingestion
Data Warehousing Summary Tables
Data Warehousing Techniques
DISTINCT removal in aggregate functions
DISTINCT removal in aggregate functions
Equality propagation optimization
FORCE INDEX
Groupwise Max in MariaDB
GUID/UUID Performance
hash_join_cardinality optimizer_switch Flag
IGNORE INDEX
not_null_range_scan Optimization
optimizer_adjust_secondary_key_costs
Optimizing for "Latest News"-style Queries
Pagination Optimization
Pivoting in MariaDB
Rollup Unique User Counts
Rowid Filtering Optimization
Sargable DATE and YEAR
Sargable UPPER
USE INDEX

filesort with small LIMIT optimization

See also

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB