Posts Tagged: Plan Cache

IndexSearch

Can You Dig It? – Determining Index Plan Usage

Posted by & filed under , , , , , , , , .

A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes.  The answer is, of course, yes, you can.  And it’s important that people, especially DBAs, understand how to do this.  Usually during index analysis, we concern ourselves with whether an index is being used. […]