# Optimizing Queries

- [Aborting Statements that Exceed a Certain Time to Execute](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/aborting-statements.md)
- [Big DELETEs](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/big-deletes.md)
- [Charset Narrowing Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/charset-narrowing-optimization.md)
- [Data Sampling: Techniques for Efficiently Finding a Random Row](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-sampling-techniques-for-efficiently-finding-a-random-row.md)
- [Data Warehousing High Speed Ingestion](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-high-speed-ingestion.md)
- [Data Warehousing Summary Tables](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-summary-tables.md)
- [Data Warehousing Techniques](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/data-warehousing-techniques.md)
- [DISTINCT removal in aggregate functions](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-optimizations-distinct-removal-in-aggregate-functions.md)
- [Equality propagation optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/equality-propagation-optimization.md)
- [Filesort with Small LIMIT Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/filesort-with-small-limit-optimization.md)
- [FORCE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/force-index.md)
- [Groupwise Max in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/groupwise-max-in-mariadb.md)
- [GUID/UUID Performance](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/guiduuid-performance.md)
- [hash\_join\_cardinality optimizer\_switch Flag](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/hash_join_cardinality-optimizer_switch-flag.md)
- [How to Quickly Insert Data Into MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/how-to-quickly-insert-data-into-mariadb.md)
- [IGNORE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/ignore-index.md)
- [Index Condition Pushdown](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-condition-pushdown.md)
- [Index Hints: How to Force Query Plans](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index-hints-how-to-force-query-plans.md)
- [index\_merge sort\_intersection](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/index_merge-sort_intersection.md)
- [LIMIT ROWS EXAMINED](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/limit-rows-examined.md)
- [MariaDB 5.3 Optimizer Debugging](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/mariadb-53-optimizer-debugging.md)
- [not\_null\_range\_scan Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/not_null_range_scan-optimization.md)
- [optimizer\_switch](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch.md)
- [optimizer\_adjust\_secondary\_key\_costs](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_adjust_secondary_key_costs.md)
- [optimizer\_join\_limit\_pref\_ratio Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer_join_limit_pref_ratio-optimization.md)
- [Optimizing for "Latest News"-style Queries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizing-for-latest-news-style-queries.md)
- [Pagination Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pagination-optimization.md)
- [Pivoting in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/pivoting-in-mariadb.md)
- [Query Limits and Timeouts](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/query-limits-and-timeouts.md)
- [reorder\_outer\_joins](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/reorder_outer_joins.md)
- [Rollup Unique User Counts](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rollup-unique-user-counts.md)
- [Rowid Filtering Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/rowid-filtering-optimization.md)
- [Sargable DATE and YEAR](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-date-and-year.md)
- [Sargable UPPER](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/sargable-upper.md)
- [USE INDEX](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/use-index.md)
- [Virtual Column Support in the Optimizer](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/virtual-column-support-in-the-optimizer.md)
- [Optimization Strategies](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies.md): Discover effective optimization strategies for MariaDB Server queries. This section provides a variety of techniques and approaches to enhance query performance and overall database efficiency.
- [Duplicate Weedout Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/duplicateweedout-strategy.md)
- [FirstMatch Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/firstmatch-strategy.md): FirstMatch is a semi-join execution strategy that avoids duplicate results by short-cutting subquery execution as soon as the first matching record is found, improving performance.
- [Improvements to ORDER BY Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/improvements-to-order-by.md)
- [LooseScan Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/loosescan-strategy.md)
- [Semi-join Materialization Strategy](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimization-strategies/semi-join-materialization-strategy.md)
- [Optimizations for Derived Tables](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables.md): Optimize derived tables in MariaDB Server queries. This section provides techniques and strategies to improve the performance of subqueries and complex joins, enhancing overall query efficiency.
- [Condition Pushdown into Derived Table Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/condition-pushdown-into-derived-table-optimization.md)
- [Derived Table Merge Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-merge-optimization.md)
- [Derived Table with Key Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-with-key-optimization.md)
- [Lateral Derived Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/lateral-derived-optimization.md): Documents Lateral Derived Optimization, also referred to as Split Grouping Optimization or Split Materialized Optimization.
- [Split Materialized Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/split-materialized-optimization.md)
- [Statistics for Optimizing Queries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries.md): Utilize statistics to optimize queries in MariaDB Server. This section explains how the database uses statistical information to generate efficient query execution plans and improve performance.
- [Engine-Independent Table Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics.md)
- [Histogram-Based Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics.md)
- [InnoDB Persistent Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/innodb-persistent-statistics.md)
- [Slow Query Log Extended Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics.md)
- [User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md)
- [Subquery Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations.md): Optimize subqueries in MariaDB Server for improved performance. This section provides techniques and best practices to ensure your nested queries execute efficiently and enhance overall query speed.
- [Condition Pushdown Into IN subqueries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/condition-pushdown-into-in-subqueries.md)
- [Conversion of Big IN Predicates Into Subqueries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/conversion-of-big-in-predicates-into-subqueries.md)
- [EXISTS-to-IN Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/exists-to-in-optimization.md)
- [Non-semi-join Subquery Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/non-semi-join-subquery-optimizations.md)
- [Optimizing GROUP BY and DISTINCT Clauses in Subqueries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/optimizing-group-by.md)
- [Semi-join Subquery Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/semi-join-subquery-optimizations.md)
- [Subquery Cache](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-cache.md)
- [Subquery Optimizations Map](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/subquery-optimizations-map.md)
- [Table Pullout Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/table-pullout-optimization.md)
- [Table Elimination](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination.md): Learn about table elimination for query optimization in MariaDB Server. This section explains how the optimizer removes unnecessary tables from query plans, improving performance.
- [Table Elimination External Resources](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-external-resources.md)
- [Table Elimination in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-mariadb.md)
- [Table Elimination in Other Databases](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-other-databases.md)
- [Table Elimination User Interface](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-user-interface.md)
- [What is Table Elimination?](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/what-is-table-elimination.md)