3월, 2017의 게시물 표시

Index 사용 현황 조회하기.

SELECT i.name, s.* FROM sys.dm_db_index_usage_stats s inner join sys.indexes i on i.object_id = s.object_id and i.index_id = s.index_id where s.object_id = Object_id('WACORe_Main.dbo.TB_Main_appointment'); https://blogs.msdn.microsoft.com/sqlserverstorageengine/2007/04/20/how-can-you-tell-if-an-index-is-being-used/