请问冗余和重复索引 这个语句能粘贴出来吗，好难写好。赞赞
请问冗余和重复索引 这个语句能粘贴出来吗，好难写好。赞赞
2 回答
select a.table_schema as '数据名', a.table_name as '表名', a.index_name as '索引1', b.index_name as '索引2', a.column_name as '重复列名' from statistics a join statistics b on a.table_schema = b.table_schema and a.table_name = b.table_name and a.seq_in_index = b.seq_in_index and a.column_name = b.column_name where a.seq_in_index = 1 and a.index_name <> b.index_name
举报
0/150
提交
取消
