Select Statement
|
|
Query Execution Plan
| SORT ORDER BY | 175 | 8 | 175 |
| NESTED LOOPS OUTER | 175 | 7 | 175 |
| NESTED LOOPS OUTER | 158 | 6 | 158 |
| NESTED LOOPS OUTER | 136 | 5 | 136 |
| NESTED LOOPS OUTER | 118 | 4 | 118 |
| TABLE
ACCESS BY INDEX ROWID ADR_FIRMA | 93 | 3 | 93 |
| INDEX
RANGE SCAN ADR_FIRMA_2 | | 2 | |
| TABLE
ACCESS BY INDEX ROWID ADR_GRUND | 25 | 1 | 25 |
| INDEX
UNIQUE SCAN SYS_C006306 | | 0 | |
| TABLE
ACCESS BY INDEX ROWID ADR_ORT | 18 | 1 | 18 |
| INDEX
UNIQUE SCAN SYS_C006312 | | 0 | |
| TABLE ACCESS BY INDEX ROWID ADR_FIRMA | 22 | 1 | 22 |
| INDEX UNIQUE SCAN SYS_C006297 | | 0 | |
| TABLE ACCESS BY INDEX ROWID ADR_PERS | 17 | 1 | 17 |
| INDEX UNIQUE SCAN SYS_C006315 | | 0 | |
| Total | 937 | 39 | |
|
