索引

plsql查看执行计划  （http://blog.csdn.net/li19236/article/details/41486557    http://blog.csdn.net/java3344520/article/details/5506718）

explain plan for select * from agreement a where a.agreementno = 'hc0025';
select * from table(DBMS_XPLAN.DISPLAY)

 

ORACLE中index的rebuild (http://blog.csdn.net/sight_/article/details/7892384)

--table move
alter table tbl move;

--rebuild索引
alter index idx_tbl_col rebuild;
alter index idx_tbl_col rebuild online;

--rename
ALTER INDEX employee_idx RENAME TO employee_index_Newname;

强制使用索引 select /*+index(t AGREEMENT_AGREEMENTNO)*/* from AGREEMENT t where t.agreementno ='hc0025'
指定优化器选择规则模式 select /*+rule*/* from AGREEMENT t where t.agreementno ='hc0025'