analyze table compute statistics
SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
SQL> create table t ( x int, y int NOT NULL );
Table created.
SQL> create unique index t_idx on t(x,y);
Index created.
SQL> insert into t values ( 1, 1 );
1 row created.
SQL> insert into t values ( NULL, 1 );
1 row created.
SQL> analyze table t compute statistics;
Table analyzed.
SQL> set autotrace on
SQL> drop table t;
Table dropped.
SQL>
SQL> set autotrace off
SQL> --
Related examples in the same category