YoumanageaSQLServer2005databasethatcontainsatablewithmanyindexes.Younoticethatdatamodificationperformancehasdegradedovertime.Yoususpectthatsomeoftheindexesareunused.YouneedtoidentifywhichindexeswerenotusedbyanyqueriessincethelasttimeSQLServer2005started.W
题目
YoumanageaSQLServer2005databasethatcontainsatablewithmanyindexes.Younoticethatdatamodificationperformancehasdegradedovertime.Yoususpectthatsomeoftheindexesareunused.YouneedtoidentifywhichindexeswerenotusedbyanyqueriessincethelasttimeSQLServer2005started.Whichdynamicmanagementviewshouldyouuse？（）
A.sys.dmftsindexpopulation
B.sys.dmexecquerystats
C.sys.dmdbindexusagestats
D.sys.dmdbindexphysicalstats
相似考题
参考答案和解析
参考答案：C