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 |
| 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. |
© 2019 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/