Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- -------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 11 | 20075 | 41 (0)| 00:00:01 |
- |* 1 | VIEW | | 11 | 20075 | 41 (0)| 00:00:01 |
- |* 2 | COUNT STOPKEY | | | | | |
- | 3 | VIEW | | 12 | 21744 | 41 (0)| 00:00:01 |
- | 4 | NESTED LOOPS | | | | | |
- | 5 | NESTED LOOPS | | 12 | 1740 | 41 (0)| 00:00:01 |
- | 6 | NESTED LOOPS OUTER | | 12 | 1440 | 29 (0)| 00:00:01 |
- | 7 | NESTED LOOPS OUTER | | 12 | 1068 | 5 (0)| 00:00:01 |
- | 8 | TABLE ACCESS BY INDEX ROWID| DID_NUMBERS | 13 | 897 | 4 (0)| 00:00:01 |
- |* 9 | INDEX RANGE SCAN | DID_NUMBERS_ENV_NUMBER | 2455K| | 3 (0)| 00:00:01 |
- | 10 | TABLE ACCESS BY INDEX ROWID| DID_OWNER_BATCHES | 1 | 20 | 1 (0)| 00:00:01 |
- |* 11 | INDEX UNIQUE SCAN | DID_OWNER_BATCHES_PK | 1 | | 0 (0)| 00:00:01 |
- | 12 | TABLE ACCESS BY INDEX ROWID | ACCOUNTS | 1 | 31 | 2 (0)| 00:00:01 |
- |* 13 | INDEX RANGE SCAN | ACCOUNTS_ENV_ID | 1 | | 1 (0)| 00:00:01 |
- |* 14 | INDEX UNIQUE SCAN | DID_VENDOR_BATCHES_PK | 1 | | 0 (0)| 00:00:01 |
- | 15 | TABLE ACCESS BY INDEX ROWID | DID_VENDOR_BATCHES | 1 | 25 | 1 (0)| 00:00:01 |
- -------------------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 1 - filter("RNUM1">1)
- 2 - filter(ROWNUM<=11)
- 9 - access("N"."I_ENV"=114)
- 11 - access("N"."I_DO_BATCH"="O"."I_DO_BATCH"(+))
- 13 - access("A"."I_ENV"(+)=114 AND NLSSORT("ID"(+),'nls_sort=''BINARY_CI''')=NLSSORT("number",'nls_
- sort=''BINARY_CI'''))
- 14 - access("N"."I_DV_BATCH"="V"."I_DV_BATCH")
Add Comment
Please, Sign In to add comment