Post reply

When was index last used

  • February 14, 2006 at 7:47 am

    #111480

    Is there any way to determine when (or if) an index was last used? I can find the creation date but not much else.


    Terry

  • February 14, 2006 at 9:22 am

    #620739

    Except for a lightweight trace, there is no way to know that in SQL Server 2000 (not sure about SQL 2005).  Oracle does have a nice feature to flag the indexes (kind of like a toggle switch) that get used - it doesn't have anything to show how many times it was used.

    But during benchmarking of a product, a lightweight trace and running all the scenarios that the user can potentially run-through in the application seems to be a nice way to get this done.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply