?
Solved

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

Posted on 2011-05-12
3
Medium Priority
?
258 Views
Last Modified: 2012-08-14
Can the order of columns in a covering index prevent the index being used?
0
Comment
Question by:Mr_Shaw
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
Maxi84 earned 2000 total points
ID: 35745329
The order of the INCLUDE columns don't matter.  The order of the index columns definitely does, and this goes for any index.
0
 

Author Closing Comment

by:Mr_Shaw
ID: 35745403
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question