|

Oracle 查询索引

Select index_name FROM user_indexes Where table_name='table_name';

analyze table t1 compute statistics for table for all indexes for all indexed columns;

set autotrace traceonly explain;


http://www.cnblogs.com/dongzhiquan/archive/2012/01/20/2328365.html


http://www.laoxiong.net/null_value_index.html

固定链接 | 评论: 0 | 引用: 0 | 查看次数: 22