• I executed below query where in found the Pages count is 5000

    but how big index is it, i didnt come to know

    =========================

    SELECT

    s.[name] AS [Schema],

    o.[name] AS [Table],

    ips.index_type_desc AS [Index Type],

    i.[name] AS [Index Name],

    i.is_primary_key AS [Primary Key],

    i.is_unique AS [Unique],

    ips.index_depth,

    i.fill_factor AS [Fill factor],

    ips.avg_fragmentation_in_percent,

    ips.fragment_count,

    ips.avg_fragment_size_in_pages,

    ips.page_count,

    o.create_date,

    o.modify_date

    FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) ips

    INNER JOIN sys.objects o ON ips.object_id = o.object_id

    INNER JOIN sys.schemAS s ON o.schema_id = s.schema_id

    INNER JOIN sys.indexes i ON i.object_id = ips.object_id

    AND i.index_id = ips.index_id

    AND ips.avg_fragmentation_in_percent > 40

    =========================

    Please suggest

    ************************************
    Every Dog has a Tail !!!!! :-D