Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Execute SYS DBMS_STATS gather_table_stats(USER, employee_job)

SQL> SQL> create table employee_job (   2  id                             number                         not null,   3  worker_id                      number                         not null,   4  logical_workplace_id           number                         not null,   5  active_date                    date          default SYSDATE  not null,   6  inactive_date                  date )   7  tablespace USERS pctfree 20   8  storage (initial 10K next 10K pctincrease 0); Table created. SQL> SQL> execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job'); PL/SQL procedure successfully completed. SQL> SQL> drop table employee_job; Table dropped.