A database index is the structure of a fact that improves the velocity of operations in a table. It can be created the usage of one or greater columns, presenting the foundation for each fast random lookups and efficient ordering of getting admission to records. Indexes are used to locate rows with specific column values quickly.

BY Best Interview Question ON 20 Sep 2022

Example

CREATE INDEX [index name] ON [table name]([column name]);