MariaDB uses indexes to quickly find rows of a query. Without indexes, MariaDB has to scan the whole table to find the relevant rows for the query.
This section teaches you about MariaDB indexes including creating new indexes, removing existing indexes, and listing all indexes in the database.
- Creating an index – show you to use the
create indexstatement to add an index for a column or a group of columns in a table to improve the speed of queries. - Dropping an index – learn how to delete an index from a table.
- Showing indexes – guide you on how to show indexes from a table.
- Unique indexes – show you how to use unique indexes to enforce distinct values in a column or a group of columns.
