MSSQL SQL SERVER 인덱스 성능 개선
인덱스의 조각이 많이 난 인덱스와 테이블명을 조회한다. SELECT -- TOP 10 -- 상위 10개만 DB_NAME() AS DatabaseName , OBJECT_NAME(S.OBJECT_ID) AS TableName , I.NAME AS IndexName , ROUND(AVG_FRAGMENTATION_IN_PERCENT, 2) AS Fragmentation FROM SYS.DM_DB_INDEX_PHYSICAL_STATS(DB_ID(),NULL,NULL,NULL,NULL) AS S INNER JOIN SYS.INDEXES AS I ON S.OBJECT_ID = I.OBJECT_ID AND S.INDEX_ID = I.INDEX_ID WHERE S.DATABASE_ID = DB_ID('DB_NAME')..
2023.07.14