Optimization and Indexes

A critical way to improve table performance is by creating indexes on key columns.

Title Description
The Essentials of an Index Explains the basics of a table index.
Getting Started with Indexes Extensive tutorial on creating indexes for tables.
Full-Text Indexes MariaDB has support for full-text indexing and searching.
ANALYZE TABLE Store key distributions for a table.
Building the best INDEX for a given SELECT Cookbook for Creating Indexes
Compound (Composite) Indexes Compound indexes plus other insights into the mysteries of indexing
EXPLAIN EXPLAIN returns information about index usage, as well as being a synonym for DESCRIBE.
Foreign Keys Foreign keys can be used to enforce data integrity
Ignored Indexes Indexes that are not used by the optimizer.
Index Statistics Index statistics and the query optimizer.
Latitude/Longitude Indexing Efficiently finding the nearest 10 pizza parlors in a huge database
Primary Keys with Nullable Columns SQL standards in dealing with multi-part primary keys with nullable columns.
SHOW EXPLAIN Shows an execution plan for a running query.
SPATIAL INDEX An index type used for geometric columns.
Storage Engine Index Types The permitted index_types for each storage engine.
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.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/optimization-and-indexes/