Question

Which of the following statements about SQL `INDEXES` is generally TRUE?

A Indexes always improve the performance of all `INSERT`, `UPDATE`, and `DELETE` operations.
B A table can have only one index.
C Indexes are primarily used to speed up data retrieval operations (`SELECT` queries).
D Indexes consume no storage space and require no maintenance.
E Indexes are automatically created for every column in a table by default.
Practice Next

Hey! Ask a query