Database Fundamentals — Question 86

One reason to add an index is to:

Answer options

• A. Decrease storage space.
• B. Increase database security.
• C. Improve performance of select statements.
• D. Improve performance of insert statements.

Correct answer: C

Explanation

Creating an index primarily aims to improve the speed and efficiency of select statements by allowing the database to find rows more quickly. Options A and B are incorrect because indexes do not necessarily reduce storage space or enhance security. Option D is also incorrect, as indexes can sometimes slow down insert operations due to the extra overhead of maintaining the index.