执行下面的SQL语句可以分析出当前数据的索引碎片情况:
SELECT object_name(dt.object_id) Tablename,si.name
IndexName,dt.avg_fragmentation_in_percent AS ExternalFragmentation,
执行下面的SQL语句可以分析出当前数据的索引碎片情况:
SELECT object_name(dt.object_id) Tablename,si.name
IndexName,dt.avg_fragmentation_in_percent AS ExternalFragmentation,