------------------------------------------------------------
    
  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