demo13.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 25 行

create table t
as
select decode(mod(rownum,2), 0, 'M', 'F' ) gender, all_objects.*
  from all_objects
/
create index t_idx on t(gender,object_id)
/
begin
        dbms_stats.gather_table_stats
        ( user, 'T', cascade=>true );
end;
/
set autotrace traceonly explain
select * from t t1 where object_id = 42;
update t
   set gender = chr(mod(rownum,256));
begin
        dbms_stats.gather_table_stats
        ( user, 'T', cascade=>true );
end;
/
set autotrace traceonly explain
select * from t t1 where object_id = 42;