Your company is having issues with indexes. You research the problem and find that, regardless of index type (primary, clustered, or non-clustered), you do not get the expected performance improvements. To resolve the issue, what should you ensure about the columns of the index?

A. They have the Allow Duplicates property set to No.
B. They are arranged from the most granular to the least granular.
C. They are arranged from the least granular to the most granular.
D. They are sorted in a different order, based on category.

  Discussion forum


Leave an answer