RE: Which indexes are used?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: mk (mk_at_discussions.microsoft.com)
Date: 11/16/04

Next message: Malin Davidsson: "Re: Which indexes are used?"
Previous message: mk: "Object Access?"
In reply to: Malin Davidsson: "Which indexes are used?"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 16 Nov 2004 06:45:04 -0800

Use SQL Profiler (scans), and also the Index Tuning Wizard if you want a
quick analysis.

Rgds,

"Malin Davidsson" wrote:

> Hi,
> Is there a way to see which indexes in a table that are used and which are
> not or is there way to see how many times an index has been used?
>
> Thanks
>
> //Malin
>
>
>

Next message: Malin Davidsson: "Re: Which indexes are used?"
Previous message: mk: "Object Access?"
In reply to: Malin Davidsson: "Which indexes are used?"
Messages sorted by: [ date ] [ thread ]