Which of the following is a reason not to create an index?
A)The field contains a large number of null values
B)The field contains a wide range of values
C)The table contains a large number of records
D)Most queries retrieve more than 2% to 4% of the table records

Question

Quizplus · Accepted Answer

Indexes are most effective for queries that retrieve a small percentage of records from a table. When most queries retrieve more than 2% to 4% of the records, the overhead of maintaining the index and the cost of index scanning might outweigh the performance benefits, making it a reason not to create an index.

Which of the Following Is a Reason Not to Create