Which of the following is used to improve performance in frequently used columns by maintaining a sort order but does not enforce constraints?
A) surrogate key
B) unique index
C) artificial key
D) nonunique index

Question

Quizplus · Accepted Answer

A nonunique index is used to improve performance in frequently used columns by maintaining a sort order, but it does not enforce constraints. Surrogate keys, artificial keys, and unique indexes all enforce constraints in addition to improving performance. Therefore, D is the correct answer.

Which of the Following Is Used to Improve Performance in Frequently