查看数据库中没有使用的索引

SELECT tb_name=object_name(a.object_id),idx_name=b.name,last_user_update,c.colid,c.keyno,col_name=d.name--INTO #TEMP06FROM sys.dm_db_index_usage_stats a LEFT JOIN sys.indexes b ON a.object_id=b.object_id AND a.index_id=b.index_idLEFT JOIN sys.sysindexkeys c ON c.id=a.object_id AND c.indid=a.index_idLEFT JOIN syscolumns d ON d.id=c.id AND d.colid=c.colidWHERE database_id=db_id()AND last_user_seek is null AND last_user_scan is null AND last_user_lookup is nullAND last_user_update is not null