Indexing

Explanation: Indexes are database objects that improve the speed of data retrieval operations.

• Why It Matters: Indexes can significantly reduce the amount of data scanned in a table, enhancing performance. However, they come with overhead on write operations (inserts, updates, deletes).
• Example: Create an index on employee_id for faster lookups: CREATE INDEX idx_employee_id ON employees(employee_id);