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?

Question

Accepted Answer

B. They are arranged from the most granular to the least granular.

Answer

A. They have the Allow Duplicates property set to No.

Answer

C. They are arranged from the least granular to the most granular.

Answer

D. They are sorted in a different order, based on category.

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…

Question

Options

How the community answered

Community Discussion