November 8, 2001 at 2:30 am
I am trying to limit the number of indexes in a database but don't know a way to determine if they are ever used. What is the best way to determine if an index is used?
November 8, 2001 at 2:52 am
To monitor over time, you could run the Profiler and select the Scan:Started event. Add IndexID to the DataColumns and perhaps SQL:StatementStarting as another event so you can correlate index useage with queries executed.
Alternatively, you can run individual queries or stored procedures in query analyser having selected Show Execution Plan.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy