Stats

• What is the optimal way to order a clustered index?

  Sep 25, 2018

  Someone recently was asking me about indexes and how the order of the columns affected the index.

  I have a table, and I want to create a clustered index on it. SSMS lets me choose the order of the columns when I make a clustered index. Logic would dictate that this must have some effect or else it wouldn’t be offered as an option. What factors are considered when determining the optimal order?