conn test/test@bilalEE
set autotrace traceonly
set timing on
alter session set statistics_level=BASIC;
drop index t1_inx_owner;
drop table t1 purge;
create index t1_inx_owner on t1(owner);
select table_name,num_rows,blocks,empty_blocks,last_analyzed from all_tables where table_name='T1';
select index_name, table_name, blevel, leaf_blocks, clustering_factor, num_rows, last_analyzed from all_indexes where index_name='T1_INX_OWNER';
alter system flush buffer_cache;
select name from t1 where owner='SYSMAN';
select name from t1 where owner='SYSMAN';
analyze table t1 compute statistics;
select table_name,num_rows,blocks,empty_blocks,last_analyzed,sample_size from all_tables where table_name='T1';
alter system flush buffer_cache;
select name from t1 where owner='SYSMAN';
alter system flush buffer_cache;
select name from t1 where owner='SYSMAN';