you can use this DMV Script to Show Index information in your database

ISNULL(INDEXPROPERTY(OBJECT_ID(,,’IndexFillFactor’),0) [fill_factor],
create_date, modify_date, ind.type_desc,
fill_factor, has_filter,
ISNULL(INDEXPROPERTY(OBJECT_ID(,,’IndexDepth’),0) [IndexDepth],
ISNULL(INDEXPROPERTY(OBJECT_ID(,,’IsAutoStatistics’),0) [IsAutoStatistics],
ISNULL(INDEXPROPERTY(OBJECT_ID(,,’IsStatistics’),0) [IsStatistics],
ISNULL(INDEXPROPERTY(OBJECT_ID(,,’IsClustered’),0) [IsClustered]
FROM sys.objects obj
INNER JOIN sys.indexes ind
ON obj.object_id = ind.object_id
WHERE obj.type = ‘U’
—and = ‘Computed_Cal’ —where you need to Show index info in Specfice table
–And ind.type_desc = ‘Heap’ — Where you need the Tables not have any Indexes

2 thoughts on “Script : index Information by Using DMV and INDEXPROPERTY Option

  1. Great blog here! Also your website loads up very fast!
    What host are you using? Can I get your affiliate link
    to your host? I wish my site loaded up as fast as yours lol


  2. Hello juyst wanted to give you a quick heads up. The words in your article seem to
    be running off the screen in Opera. I’m not sure iff this is a format issue or something to do with web browser compatibility but I thought
    I’d post to let you know. The layout look great though!

    Hoope you get the problem fixed soon. Many thanks


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.