What is an index in a database primarily used for?
- A Speeding up reads by allowing the engine to locate rows without scanning the table
- B Reducing storage size
- C Enforcing data types
- D Compressing data
Answer
Speeding up reads by allowing the engine to locate rows without scanning the table
Indexes slow down writes, since every insert and update must maintain them, so they are a trade-off rather than a free improvement.





