An index is a database structure that you can use to improve the performance of database activity.

To construct indexes, use the construct INDEX command:
index_name on table_name(column1, column2,…, columnN); — create an index on a single column; create an index on products(category);… — create an index on multiple columns build a products_category_brand index on products(category, brand_id);