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 significant variety in attribute values.

D) all of the above.

Answer is D. Already solved, thanks!