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

Answer 1

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]

Answer 2

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