Answered by:
Information about indexes

Question
-
Hi all,
i'm using sql server 2008r2, i have found a table which is having 35 indexes and this is our main transaction table. Here i found a job which creates missing indexes automatically.what im getting confused is it is having multiple indexes on a single column with different columns in include clause. can i create a single index with all that including columns?
can u please help me to know the concept of include clause in indexes.
Thanks
Vinesh M
Monday, August 29, 2016 9:16 AM
Answers
-
Please avoid double Posts: https://social.msdn.microsoft.com/Forums/en-US/e2edf584-61bb-48c1-a3a5-2bb3a739f40f/information-about-indexes?forum=databasedesign
Olaf Helper
[ Blog] [ Xing] [ MVP]- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, September 9, 2016 1:21 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, October 30, 2016 1:39 AM
Monday, August 29, 2016 10:10 AMAnswerer -
Yes, you can.
Having a job to automatically create indexes from missing index query is not a good idea. One reason is exactly what you are seeing.
You need to stop the job and look closer at why they are being suggested. It probably because they add or subtract columns from their original query while looking at the data.
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, September 9, 2016 1:21 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, October 30, 2016 1:39 AM
Monday, August 29, 2016 4:12 PM
All replies
-
Please avoid double Posts: https://social.msdn.microsoft.com/Forums/en-US/e2edf584-61bb-48c1-a3a5-2bb3a739f40f/information-about-indexes?forum=databasedesign
Olaf Helper
[ Blog] [ Xing] [ MVP]- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, September 9, 2016 1:21 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, October 30, 2016 1:39 AM
Monday, August 29, 2016 10:10 AMAnswerer -
Yes, you can.
Having a job to automatically create indexes from missing index query is not a good idea. One reason is exactly what you are seeing.
You need to stop the job and look closer at why they are being suggested. It probably because they add or subtract columns from their original query while looking at the data.
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, September 9, 2016 1:21 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Sunday, October 30, 2016 1:39 AM
Monday, August 29, 2016 4:12 PM