1
Query Optimizations
Different query optimizations and how you can use and tune them to get better performance.
-
Index Hints: How to Force Query Plans
Using hints to get the optimizer to use another query plan. -
Subquery Optimizations
Articles about subquery optimizations in MariaDB. -
Optimization Strategies
Various optimization strategies used by the query optimizer. -
Optimizations for Derived Tables
Optimizations for derived tables, or subqueries in the FROM clause -
Table Elimination
Resolving queries without accessing some of the tables the query refers to -
Statistics for Optimizing Queries
Different statistics provided by MariaDB to help you optimize your queries -
MIN/MAX optimization
How MIN and MAX are optimized -
Filesort with Small LIMIT Optimization
MariaDB 10's filesort with small LIMIT optimization -
LIMIT ROWS EXAMINED
Means to terminate execution of SELECTs that examine too many rows. -
Block-Based Join Algorithms
Algorithms that employ a join buffer for the first join before starting to look in the second. -
index_merge sort_intersection
Operation to allow the use of index_merge in a broader number of cases -
MariaDB 5.3 Optimizer Debugging
MariaDB 5.3's optimizer debugging patch -
optimizer_switch
Server variable for enabling specific optimizations. -
Extended Keys
Optimization using InnoDB/XtraDB key components to generate more efficient execution plans. -
How to Quickly Insert Data Into MariaDB
Techniques for inserting data quickly into MariaDB. -
Index Condition Pushdown
Index Condition Pushdown optimization -
Query Limits and Timeouts
Different methods MariaDB provides to limit/timeout a query. -
Aborting Statements that Exceed a Certain Time to Execute
Aborting statements that take longer than a certain time to execute. -
Partition Pruning and Selection
Partition pruning is when the optimizer knows which partitions are relevant for the query. -
Big DELETEs
How to DELETE lots of rows from a large table -
Data Sampling: Techniques for Efficiently Finding a Random Row
Fetching random rows from a table (beyond ORDER BY RAND()) -
Data Warehousing High Speed Ingestion
Ingesting lots of data and performance is bottlenecked in the INSERT area. What to do? -
Data Warehousing Summary Tables
Creation and maintenance of summary tables -
Data Warehousing Techniques
Improving performance for data-warehouse-like tables -
Equality propagation optimization
Basic idea Consider a query with a WHERE clause: WHERE col1=col2 AND ... t... -
FORCE INDEX
Similar to USE INDEX, but tells the optimizer to regard a table scan as very expensive. -
Groupwise Max in MariaDB
Finding the largest row for each group -
GUID/UUID Performance
GUID/UUID performance (type 1 only) -
IGNORE INDEX
Tell the optimizer to not consider a particular index. -
not_null_range_scan Optimization
Enables constructing range scans from NOT NULL conditions inferred from the WHERE clause. -
Optimizing for "Latest News"-style Queries
Optimizing the schema and code for "Latest News"-style queries -
Pagination Optimization
Pagination, not with OFFSET, LIMIT -
Pivoting in MariaDB
Pivoting data so a linear list of values with two keys becomes a spreadsheet-like array -
Rollup Unique User Counts
Technique for counting unique users -
Rowid Filtering Optimization
Rowid filtering is an optimization available from MariaDB 10.4. -
USE INDEX
Find rows in the table using only one of the named indexes.
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.
