A rule of thumb for choosing indexes is to:
A) be careful indexing attributes that may be null.
B) index each primary key of each table.
C) use an index when there is variety in attribute values.
D) all of the above.

Question

Quizplus · Accepted Answer

All the options are valid considerations when choosing indexes: avoiding null attributes, indexing primary keys, and using indexes for attributes with diverse values.

A Rule of Thumb for Choosing Indexes Is To