摘要: 1、抓出外键没有创建索引的表(不依赖统计信息)with cons as (select /*+ materialize */ owner,table_name,constraint_name from dba_constraints where owner='SCOTT' and constrain 阅读全文
posted @ 2019-04-28 10:41 钱若梨花落 阅读(368) 评论(0) 推荐(0) 编辑
摘要: SELECT /*+ rule */ a .table_owner, a.table_name, a.index_owner, a.index_name, column_name_list, column_name_list_dup, dup duplicate_indexes, i.uniquen 阅读全文
posted @ 2019-04-28 10:36 钱若梨花落 阅读(777) 评论(0) 推荐(0) 编辑