The purpose of creating databases indexes is to _____.
A) maintain the integrity of the data stored in tables
B) reduce the database's storage (memory) requirements
C) avoid searching through every row in a table with every query
D) grant and/or revoke privileges for certain actions to users

Question

Quizplus · Accepted Answer

Indexes are created to improve the performance of search queries by allowing the database system to find data without having to search every row in a table every time a query is executed.

The Purpose of Creating Databases Indexes Is to _____