SQL Server - Missing Indexes - What would use the index?
Posted
by BankZ
on Stack Overflow
See other posts from Stack Overflow
or by BankZ
Published on 2010-06-04T12:10:16Z
Indexed on
2010/06/05
10:42 UTC
Read the original article
Hit count: 143
I am using SQL Server 2008 and we are using the DMV's to find missing indexes. However, before I create the new index I am trying to figure out what proc/query is wanting that index. I want the most information I can get so I can make informed decision on my indexes. Sometimes the indexes SQL Server wants does not make sense to me. Does anyone know how I can figure out what wants it?
© Stack Overflow or respective owner