Post reply

Index not appearing on Table in EM

  • November 23, 2003 at 7:54 pm

    #107012

    Hi,

    This is my first post so please be patient. I have a table in my database that has 8 indexes viewable through EM. However when I query the database (as below) I get a number more. Those indexes appearing in the query yet not in EM have a value of 0 in the ROWS column.

    SELECT * FROM sysindexes where id = OBJECT_ID('table_name')

    Is this anything to be worried about and if so what is the best way to delete these indexes, as I am sure they are not being used.

    Thanks


    Matthew Erbs

  • November 24, 2003 at 1:16 am

    #483282

    Are those indexes named something '__WA*?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 24, 2003 at 1:17 am

    #483283

    What are the names of the indexes that aren't listed in EM?

    If they all start with '_WA', then they are the statistics that SQL Server builds on non indexed columns if you have the 'Auto Create Statistics' option on, so don't worry about them.

  • November 24, 2003 at 3:50 pm

    #483465

    Yes they are all WA_

    Thanks for the tip

    Matthew Erbs


    Matthew Erbs

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

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