• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Can the order of columns in a covering index prevent the index being used?

Can the order of columns in a covering index prevent the index being used?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 2
1 Solution
 
Maxi84Commented:
The order of the INCLUDE columns don't matter.  The order of the index columns definitely does, and this goes for any index.
0
 
Mr_ShawAuthor Commented:
Thanks
0
 
Mr_ShawAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now