Indexing Tables

Indexes are used to speed up query performance. You can create an index using the CREATE INDEX statement:

Syntax:

CREATE INDEX index_name ON table_name (column_name);

Example:

CREATE INDEX idx_salary ON employees (salary);

This creates an index named idx_salary on the salary column of the employees table.