YoumanageaSQLServer2005databasethatcontainsatablewithmanyindexes.Younoticethatdatamodificationperformancehasdegradedovertime.Yoususpectthatsomeoftheindexesareunused.YouneedtoidentifywhichindexeswerenotusedbyanyqueriessincethelasttimeSQLServer2005started.Whichdynamicmanagementviewshouldyouuse?()

A.sys.dmftsindexpopulation B.sys.dmexecquerystats C.sys.dmdbindexusagestats D.sys.dmdbindexphysicalstats

时间:2024-01-16 13:00:46

相似题目