MySQL Database

MySQL Create Index

Improve lookups and sorting with an index.

CREATE INDEX idx_products_name
ON products (name);

Indexes can speed reads but add storage and write overhead. Index columns used frequently in filters, joins, or ordering.