Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Check table status with SYS DBMS_STATS gather_table_stats after adding index

SQL> SQL> CREATE TABLE employee_evaluation (   2  id            number,   3  title         varchar2(100),   4  written_date  date ); Table created. SQL> SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(100,'SQL',to_date('19700101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(100,'Java',to_date('19900101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(200,'C++',to_date('20030101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(200,'C',to_date('20000101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(200,'Oracle',to_date('20020101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)VALUES(200,'Theory',to_date('20050101', 'YYYYMMDD') ); 1 row created. SQL> INSERT INTO employee_evaluation(id,title,written_date)values(300,'Third',to_date('20000101', 'YYYYMMDD')   2  INSERT INTO employee_evaluation(id,title,written_date)values(300,'Data',to_date('20020101', 'YYYYMMDD')   3 SQL> SQL> CREATE INDEX employee_evaluation_k1   2  on           employee_evaluation (   3  title ); Index created. SQL> SQL>EXEC SYS.DBMS_STATS.gather_table_stats(USER, UPPER('employee_evaluation')); SQL> SQL> drop table employee_evaluation; Table dropped. SQL>