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 traceonlyselect * from t where object_id = 10;drop table t;--