19 嵌套循环成本计算--优化主题系列

嵌套循环成本计算(请自己跟着做实验计算一下)

 

select * from v$version where rownum=1; --11.2.0.1.0

create table t1 as select object_id id , object_name,owner fromdba_objects;

create table t2 as select object_id id , status,temporary fromdba_objects;

BEGIN

  DBMS_STATS.GATHER_TABLE_STATS(ownname         => 'TEST',

                               tabname          => 'T1',

                               estimate_percent => 100,

                               method_opt       => 'for all columns sizeAUTO',

                               degree           =>DBMS_STATS.AUTO_DEGREE,

                               cascade         => TRUE);

END;

/

BEGIN

 DBMS_STATS.GATHER_TABLE_STATS(ownname         => 'TEST',

                               tabname          => 'T2',

                               estimate_percent => 100,

                               method_opt       => 'for all columns sizeAUTO',

                               degree           =>DBMS_STATS.AUTO_DEGREE,