Execution Plan
----------------------------------------------------------
Plan hash value: 2088285980

------------------------------------------------------------------------------------
| Id  | Operation             | Name       | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |            |  1298 |   103K|  6449M  (1)|999:59:59 |
|   1 |  HASH GROUP BY        |            |  1298 |   103K|  6449M  (1)|999:59:59 |
|   2 |   NESTED LOOPS OUTER  |            |   749K|    58M|  6449M  (1)|999:59:59 |
|   3 |    TABLE ACCESS FULL  | NUMUNEONOS |   749K|    39M|  8600   (1)| 00:01:44 |
|   4 |    VIEW               |            |     1 |    27 |  8600   (1)| 00:01:44 |
|*  5 |     FILTER            |            |       |       |            |          |
|*  6 |      TABLE ACCESS FULL| NUMUNEONOS |     1 |    55 |  8600   (1)| 00:01:44 |
------------------------------------------------------------------------------------