Optimization and Indexes
Need help tuning your MariaDB database? Ask the experts!
Contact UsA critical way to improve table performance is by creating indexes on key columns.
-
The Essentials of an Index
Explains the basics of a table index. -
Getting Started with Indexes
Extensive tutorial on creating indexes for tables. -
CREATE INDEX
Create an index on one or more columns. -
DROP INDEX
Drops an index from a table. -
SHOW INDEX
Information about table indexes. -
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.