Post reply

_WA_ indexes ??

  • May 1, 2006 at 9:02 am

    #169248

    Hi,

      I have a 30GB DB OLTP. When I run select * from sysindexes, I see lot of _WA entries in there. I have the 'Auto create stats' and 'Auto update stats' options turned on.

    1 ) Do I need to convert these _WA indexes to a permanent index for better performance ? or just leave it out there ?

    2) If I need to convert to a permanent index, where do I see the DDL for that ?

    TIA

    Moe

  • May 1, 2006 at 9:19 am

    #635141

    Those are just statistics that the server is using for the queries (or used only once). The index tuning wizard could point out some new indexes to use. But the best way is to analyse the queries you are running to see if you could add another index.

    Another way would be to drop all those stats abd come back at the end of the day to see which one were recreated. That could give you some pointers.

  • May 3, 2006 at 10:58 am

    #635717

    I concur with RGR,us.  That is what they are and they are handy for hints on where to add indexes. 

    Luck and Cheers!

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

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