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; --