Post reply

How to find usused indexes in any database ?

  • May 18, 2007 at 1:32 pm

    #178996

    Hi everyone,

    How can we find the unused indexes in MS SQL SERVER 2000 database ?

    Is anyone have any scripts to find that ?

    Help me.

     

    Thanks

     

    AKP

  • May 18, 2007 at 1:45 pm

    #707574

    Start Profiler.

    _____________
    Code for TallyGenerator

  • May 18, 2007 at 1:48 pm

    #707575

    We need to take full workload to use SQL profiler. If we need to do in production database, it will be problemmatic. If there is any script which can find the list of unused indexes, that will better for to solve my problem.

     

    Thanks

    AKP

  • May 18, 2007 at 1:55 pm

    #707578

    You don't need full workload.

    You need only indexes used during selects.

    What kind of script will tell you which keys on you keyboard are unused?

    You need to see all texts you typed, right? Nothing to do with your keyboard.

    _____________
    Code for TallyGenerator

Viewing 4 posts - 1 through 3 (of 3 total)

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