Analyze a table with/without index
create table indextest as select * from dba_objects where owner in ('OUTLN','PUBLIC','SCOTT','SYS','SYSTEM'); analyze table indextest compute statistics; set autotrace trace explain select owner, object_name from indextest where object_name = 'DBA_INDEXES'; create index indxtest_objname_idx on indextest (object_name); select owner, object_name from indextest where object_name = 'DBA_INDEXES'; set autotrace off; drop table indextest;