특정 DB 내 모든 인덱스 조각화 정보 조회 : 조회하려는 DB에서 실행USE [DB명] GO SELECT db_name(db_id()) AS DBName , schema_name(tmp2.schema_id) AS SchemaName , tmp2.name AS TableName , tmp3.name AS IdxName , ROUND(tmp1.AVG_FRAGMENTATION_IN_PERCENT, 2) AS 'Fragmentation %' FROM (SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(db_name()), NULL, NULL, NULL, NULL) ) AS tmp1 LEFT OUTER JOIN sys.tables AS tmp2 ON tmp1.objec..