optimizer mode=choose: 表在A列上有索引 select * from table_name where a=** or a=**; select * from table_name where a in (**,**,**); select * from table_name where a between ** and **; 以上三条语句均导致全表扫描 table access full 用HINTS强制为RBO select /*+rule*/ * from table_name where a=** or a=**; select /*+rule*/ * from table_name where a in (**,**,**); select /*+rule*/ * from table_name whe...
by 寒鸦 - Oracle - 2006-08-08 23:11:40 阅读(1869) 回复(5)