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