Mega Code Archive
Set autotrace traceonly
create table t as
select *
from all_objects
where rownum < 10001;
create index t_idx on t(object_id);
analyze table t compute statistics;
set autotrace traceonly
select * from t where object_id = 10;
drop table t;
--