What is an Index and why would you use it?

n Index is a database object that speeds up the retrieval of rows from a table by creating a

data structure (often a B-tree). Indexes improve the performance of SELECT queries but can

slow down INSERT, UPDATE, and DELETE operations.

Example:

CREATE INDEX idx_employee_name ON Employees(Name);