-------------------------------------------------------------------------------------------------------------------
| Id   | Operation                            | Name                        | Rows   | Bytes   | Cost  | Time     |
-------------------------------------------------------------------------------------------------------------------
|    0 | SELECT STATEMENT                     |                             |      1 |     106 | 90411 | 00:18:05 |
|    1 |   HASH GROUP BY                      |                             |      1 |     106 | 90411 | 00:18:05 |
|    2 |    NESTED LOOPS                      |                             |      1 |     106 | 90410 | 00:18:05 |
|    3 |     NESTED LOOPS                     |                             |      1 |     106 | 90410 | 00:18:05 |
|    4 |      NESTED LOOPS                    |                             |      1 |      89 | 90409 | 00:18:05 |
|    5 |       NESTED LOOPS                   |                             |      1 |      73 | 90408 | 00:18:05 |
|  * 6 |        HASH JOIN                     |                             | 151424 | 8176896 | 29789 | 00:05:58 |
|    7 |         TABLE ACCESS FULL            | OPERACAO                    |    241 |    3856 |     3 | 00:00:01 |
|    8 |         NESTED LOOPS                 |                             | 146397 | 5563086 | 29785 | 00:05:58 |
|    9 |          NESTED LOOPS                |                             | 146397 | 5563086 | 29785 | 00:05:58 |
|   10 |           VIEW                       | index$_join$_006            | 146288 | 2340608 |   502 | 00:00:07 |
| * 11 |            HASH JOIN                 |                             |        |         |       |          |
|   12 |             INDEX FAST FULL SCAN     | IX_ESTOQUE_LOCAL_OPERACAO_5 | 146288 | 2340608 |    58 | 00:00:01 |
|   13 |             INDEX FAST FULL SCAN     | PK_ESTOQUE_LOCAL_OPERACAO   | 146288 | 2340608 |    41 | 00:00:01 |
| * 14 |           INDEX UNIQUE SCAN          | PK_LOCAL                    |      1 |         |     1 | 00:00:01 |
|   15 |          TABLE ACCESS BY INDEX ROWID | LOCAL                       |      1 |      22 |     1 | 00:00:01 |
| * 16 |        TABLE ACCESS BY INDEX ROWID   | EQUIPAMENTO                 |      1 |      19 |     1 | 00:00:01 |
| * 17 |         INDEX RANGE SCAN             | IX_EQUIPAMENTO_2            |      1 |         |     1 | 00:00:01 |
|   18 |       TABLE ACCESS BY INDEX ROWID    | TIPO_LOCAL                  |      1 |      16 |     1 | 00:00:01 |
| * 19 |        INDEX UNIQUE SCAN             | PK_TIPO_LOCAL               |      1 |         |     1 | 00:00:01 |
| * 20 |      INDEX UNIQUE SCAN               | PK_ESTADO_EQUIPAMENTO       |      1 |         |     1 | 00:00:01 |
|   21 |     TABLE ACCESS BY INDEX ROWID      | ESTADO_EQUIPAMENTO          |      1 |      17 |     1 | 00:00:01 |
-------------------------------------------------------------------------------------------------------------------