List the different index configurations possible for a table?

› Category: SQL › List the different index configurations possible for a table?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

List the different index configurations possible for a table?

Question Tags:
1 Answers
0 Vote Up Vote Down
Editor">Editor Staff answered 2 years ago

A table can have one of the following index configurations:

  • No indexes
  • A clustered index
  • A clustered index and many non-clustered indexes
  • A non-clustered index
  • Many non-clustered indexes