Common SQL Performance Statistics code

1 BEGIN2Dbms_stats. Gather_table_stats (ownname=>'Teledb', tabname=>'wfgtest', partname=>NULL);3 END;4 ALTER TABLE wfgtest deallocate UNUSED;5 COMMIT;6 7 SELECT table_name,num_rows,blocks,empty_blocks8 From user_tables9WHERE table_name='wfgtest';Ten  OneSELECT COUNT (1) from Wfgtest; A  - DELETE from Wfgtest; - COMMIT; the  - TRUNCATE TABLE wfgtest; - COMMIT; -  +SELECT *From Wfgtest; -  + DECLARE ANUM Number ( -); at DT1 DATE; - BEGIN -NUM: =1; -DT1: =sysdate (); -For NUM in1..1000000 - LOOP in INSERT into Wfgtest VALUES (To_char (num), to_char (num), num); - END LOOP; to COMMIT; +  -Dbms_output. Put_Line (Floor (To_number (SYSDATE-DT1) * -* -* -)); the  *END;

Common SQL Performance Statistics code