Multiple Choice
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.
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q2: The query processor always knows the best
Q7: Vertical partitioning means distributing the columns of
Q9: Distributing the rows of data into separate
Q34: An index on columns from two or
Q40: Another form of denormalization where the same
Q56: List the seven factors to consider when
Q103: A join index is a combination of
Q112: Indexes are most useful on small, clustered
Q120: One method to handle missing values is
Q151: An extent is a named portion of