Session altered. Elapsed: 00:00:00.00 Sequence dropped. Elapsed: 00:00:00.08 Table dropped. Elapsed: 00:00:00.14 Table created. Elapsed: 00:00:00.03 Table altered. Elapsed: 00:00:00.02 Index created. Elapsed: 00:00:00.01 Sequence created. Elapsed: 00:00:00.01 PL/SQL procedure successfully completed. Elapsed: 00:05:38.06 Table analyzed. Elapsed: 00:00:31.88 Index analyzed. Elapsed: 00:00:00.86 Index analyzed. Elapsed: 00:00:00.89 COUNT(*) ---------- 1800000 Elapsed: 00:00:01.57 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE' Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4577 consistent gets 4570 physical reads 0 redo size 492 bytes sent via SQL*Net to client 651 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed CREATE_DA COUNT(TXN_ID) --------- ------------- 08-MAY-05 50000 09-MAY-05 50000 10-MAY-05 50000 11-MAY-05 50000 12-MAY-05 50000 13-MAY-05 50000 14-MAY-05 50000 15-MAY-05 50000 16-MAY-05 50000 17-MAY-05 50000 18-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 19-MAY-05 50000 20-MAY-05 50000 21-MAY-05 50000 22-MAY-05 50000 23-MAY-05 50000 24-MAY-05 50000 25-MAY-05 50000 26-MAY-05 50000 27-MAY-05 50000 28-MAY-05 50000 29-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 30-MAY-05 50000 31-MAY-05 50000 01-JUN-05 50000 02-JUN-05 50000 03-JUN-05 50000 04-JUN-05 50000 05-JUN-05 50000 06-JUN-05 50000 07-JUN-05 50000 08-JUN-05 50000 09-JUN-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 10-JUN-05 50000 11-JUN-05 50000 12-JUN-05 50000 36 rows selected. Elapsed: 00:00:03.46 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (GROUP BY) 2 1 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE' Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4577 consistent gets 3712 physical reads 0 redo size 1462 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 36 rows processed 250000 rows deleted. Elapsed: 00:00:14.63 Execution Plan ---------------------------------------------------------- 0 DELETE STATEMENT Optimizer=RULE 1 0 DELETE OF 'TRANS_SAMPLE' 2 1 INDEX (RANGE SCAN) OF 'TRANS_SAMPLE_DATE_IDX' (NON-UNIQU E) Statistics ---------------------------------------------------------- 98 recursive calls 1021250 db block gets 720 consistent gets 2675 physical reads 126285672 redo size 803 bytes sent via SQL*Net to client 718 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 1 sorts (memory) 1 sorts (disk) 250000 rows processed COUNT(*) ---------- 1550000 Elapsed: 00:00:01.33 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE' Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4577 consistent gets 4133 physical reads 0 redo size 492 bytes sent via SQL*Net to client 651 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed CREATE_DA COUNT(TXN_ID) --------- ------------- 13-MAY-05 50000 14-MAY-05 50000 15-MAY-05 50000 16-MAY-05 50000 17-MAY-05 50000 18-MAY-05 50000 19-MAY-05 50000 20-MAY-05 50000 21-MAY-05 50000 22-MAY-05 50000 23-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 24-MAY-05 50000 25-MAY-05 50000 26-MAY-05 50000 27-MAY-05 50000 28-MAY-05 50000 29-MAY-05 50000 30-MAY-05 50000 31-MAY-05 50000 01-JUN-05 50000 02-JUN-05 50000 03-JUN-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 04-JUN-05 50000 05-JUN-05 50000 06-JUN-05 50000 07-JUN-05 50000 08-JUN-05 50000 09-JUN-05 50000 10-JUN-05 50000 11-JUN-05 50000 12-JUN-05 50000 31 rows selected. Elapsed: 00:00:02.92 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (GROUP BY) 2 1 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE' Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4577 consistent gets 4133 physical reads 0 redo size 1350 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 31 rows processed