SQL> create table t1 as select * from dba_objects;
SQL> create index i1_idx on t1(owner);
BEGIN
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'TEST',
tabname => 't1',
estimate_percent => 30,
method_opt => 'for all columns size repeat',
no_invalidate => FALSE,
degree => 8,
cascade => TRUE);
END;
SQL> select * from t1 where owner='TEST';
已选择3328行。
执行计划
----------------------------------------------------------
Plan hash value: 1104552013
--------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------
index range scan 单块读 无法走并行
最新推荐文章于 2020-07-06 20:29:10 发布