Get table statistics : Table Statistics « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Table Statistics

Get table statistics

create table t as select * from all_objects where rownum < 60;

exec dbms_stats.gather_table_stats( user, 'T' );

alter session set workarea_size_policy=manual;

alter session set sort_area_size = 65536;

set termout off
select * from t order by 1, 2, 3, 4;

set termout on
alter session set sort_area_size=1048576;
set termout off
select * from t order by 1, 2, 3, 4;

set termout on
alter session set sort_area_size=1073741820;
set termout off
select * from t order by 1, 2, 3, 4;

set termout on

drop table t;



           
       

Related examples in the same category