Post reply

Index usage

  • November 8, 2001 at 2:30 am

    #77919

    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

    #419812

    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@btinternet.com


    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