demo15.sql

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

create table t
( x, y , primary key (x) )
as
select rownum x, object_name
  from all_objects
/
begin
   dbms_stats.gather_table_stats
   ( user, 'T', cascade=>true );
end;
/
set autotrace on explain
select count(y) from t where x < 50;
select count(y) from t where x < 15000;