Post reply

Show all indexes with names

  • March 30, 2011 at 2:49 am

    #235967

    Hi!

    I would like to see the name, id and framentation of all indexes in all db:s.

    Not only the ID, i need the full names.

    Is there any easy way to do this?

  • March 30, 2011 at 3:07 am

    #1305305

    Query sys.dm_db_index_physical_stats, join to sys.indexes (for the index name0, join to sys.tables or use the Object_Name function for the table name.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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