The purpose of an index is to ____.
A) speed up DML operations
B) speed up full table scans
C) efficiently determine whether a value exists in a table
D) all of the above

Question

The purpose of an index is to ____.​
A) ​speed up DML operations
B) ​speed up full table scans
C) ​efficiently determine whether a value exists in a table
D) ​all of the above

Quizplus · Accepted Answer

Indexes are primarily used to enhance database performance by allowing faster retrieval of records from a table. They make it efficient to determine if a value exists in a table without having to scan the entire table, which can be time-consuming for large tables.

The Purpose of an Index Is to ____.​

The Purpose of an Index Is to ____.