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;
Related examples in the same category