Monday, March 19, 2012

Locate Covered Indexes on Tables

I am looking for the stored procedure that have the covered indexes for
several indexes in my database.
Is there a script or way to determine the which stored procedures correspond
to the covered indexes?
Thank You,Joe
Let me understand you. COVERING indexes are created on columns not on stored
procedures.
Can you elaborate a little bit what you are trying to accomplish?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:D3FE0DDD-C12B-49EF-A02A-FFC8AA751E53@.microsoft.com...
> I am looking for the stored procedure that have the covered indexes for
> several indexes in my database.
> Is there a script or way to determine the which stored procedures
> correspond
> to the covered indexes?
> Thank You,

No comments:

Post a Comment