摘要: DECLARE @tbl nvarchar(265) SELECT @tbl = '' SELECT o.name,i.index_id, i.name, i.type_desc, substring(ikey.cols, 3, len(ikey.cols))AS key_cols, substri 阅读全文
posted @ 2020-07-27 15:28 淡青 阅读(173) 评论(0) 推荐(0)
摘要: select c.unique_compiles as 将从该缺失索引组受益的编译和重新编译数, c.user_seeks as 建索引后可能的使用查找次数, c.user_scans as 建索引后可能的使用扫描次数, c.statement as 表名, c.equality_columns, 阅读全文
posted @ 2020-07-27 14:19 淡青 阅读(180) 评论(0) 推荐(0)