rendered paste body ------------------------------------------------------------
Statement Id=484 Type=
Cost=1,95950019352235E-307 TimeStamp=01-12-06::12::28:39
(1) SELECT STATEMENT CHOOSE
Est. Rows: 5 479 Cost: 1 223 134 635
(27) SORT GROUP BY
Est. Rows: 5 479 Cost: 1 223 134 635
(26) HASH JOIN
Est. Rows: 1 975 318 160 Cost: 9 503
(7) VIEW (Embedded SQL)
Est. Rows: 8 699 Cost: 138
(6) UNION-ALL
(2) TABLE ACCESS FULL SYS.DUAL [Not Analyzed]
(2) Est. Rows: 8 168 Cost: 47
Tablespace: SYSTEM
(5) PARTITION HASH ALL
(4) TABLE ACCESS BY LOCAL INDEX ROWID KOMTEL.OBJECTRELATION [Analyzed]
Blocks: 7 114 Est. Rows: 531 of 1 468 960 Cost: 91
(3) NON-UNIQUE INDEX RANGE SCAN KOMTEL.IDX$OBJ_RELATION_PARENTOBJID [Analyzed]
Est. Rows: 531 Cost: 67
(25) HASH JOIN
Est. Rows: 176 436 626 Cost: 7 758
(13) VIEW SYS.VW_NSO_1
Est. Rows: 8 177 Cost: 50
(12) SORT UNIQUE
Est. Rows: 8 177 Cost: 50
(11) UNION-ALL
(8) TABLE ACCESS FULL SYS.DUAL [Not Analyzed]
(8) Est. Rows: 8 168 Cost: 47
Tablespace: SYSTEM
(10) TABLE ACCESS BY INDEX ROWID KOMTEL.OBJECTTYPEPARENT [Analyzed]
(10) Blocks: 5 Est. Rows: 9 of 1 256 Cost: 3
Tablespace: USERS
(9) NON-UNIQUE INDEX RANGE SCAN KOMTEL.XIF1197OBJECTTYPEPARENT [Analyzed]
Est. Rows: 9 Cost: 2
(24) HASH JOIN
Est. Rows: 194 195 Cost: 5 960
(14) TABLE ACCESS FULL KOMTEL.DATEHASH [Analyzed]
(14) Blocks: 35 Est. Rows: 5 479 of 5 479 Cost: 18
Tablespace: USERS
(23) HASH JOIN
Est. Rows: 194 195 Cost: 5 940
(17) PARTITION RANGE ITERATOR
(16) PARTITION HASH ALL
(15) TABLE ACCESS FULL KOMTEL.SERVICEUSAGE [Analyzed]
Blocks: 12 729 Est. Rows: 194 110 of 533 694 Cost: 1 970
(22) HASH JOIN
Est. Rows: 556 232 Cost: 2 113
(18) UNIQUE INDEX FAST FULL SCAN KOMTEL.SYS_C003691 [Analyzed]
Est. Rows: 1 440 Cost: 4
(21) PARTITION RANGE ALL
(20) PARTITION HASH ALL
(19) TABLE ACCESS FULL KOMTEL.SERVICEUSAGESESSION [Analyzed]
Blocks: 4 694 Est. Rows: 556 232 of 556 232 Cost: 2 104