What does a SQL INDEX do?

Question

Advanced SQL Developer — Hard

What does a SQL INDEX do?

Accepted Answer

A SQL INDEX optimizes query performance by facilitating faster data location. It achieves this by storing a data structure that enables swift lookup. The correct answer, "Speeds up data retrieval", is accurate because an index allows the database to quickly locate specific data. In contrast, options like "Deletes duplicate rows" and "Encrypts data" are unrelated to indexing.