daily pastebin goal
56%
SHARE
TWEET

Untitled

a guest Aug 10th, 2018 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -------------------------------------------------------------------------------------------------------------
  2. | Id  | Operation              | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
  3. -------------------------------------------------------------------------------------------------------------
  4. |   0 | SELECT STATEMENT           |                |    11 | 20075 |    41   (0)| 00:00:01 |
  5. |*  1 |  VIEW                  |                |    11 | 20075 |    41   (0)| 00:00:01 |
  6. |*  2 |   COUNT STOPKEY            |                |       |       |        |      |
  7. |   3 |    VIEW                |                |    12 | 21744 |    41   (0)| 00:00:01 |
  8. |   4 |     NESTED LOOPS           |                |       |       |        |      |
  9. |   5 |      NESTED LOOPS          |                |    12 |  1740 |    41   (0)| 00:00:01 |
  10. |   6 |       NESTED LOOPS OUTER       |                |    12 |  1440 |    29   (0)| 00:00:01 |
  11. |   7 |        NESTED LOOPS OUTER      |                |    12 |  1068 |     5   (0)| 00:00:01 |
  12. |   8 |     TABLE ACCESS BY INDEX ROWID| DID_NUMBERS        |    13 |   897 |     4   (0)| 00:00:01 |
  13. |*  9 |      INDEX RANGE SCAN      | DID_NUMBERS_ENV_NUMBER |  2455K|       |     3   (0)| 00:00:01 |
  14. |  10 |     TABLE ACCESS BY INDEX ROWID| DID_OWNER_BATCHES      |     1 |    20 |     1   (0)| 00:00:01 |
  15. |* 11 |      INDEX UNIQUE SCAN     | DID_OWNER_BATCHES_PK   |     1 |       |     0   (0)| 00:00:01 |
  16. |  12 |        TABLE ACCESS BY INDEX ROWID | ACCOUNTS           |     1 |    31 |     2   (0)| 00:00:01 |
  17. |* 13 |     INDEX RANGE SCAN       | ACCOUNTS_ENV_ID        |     1 |       |     1   (0)| 00:00:01 |
  18. |* 14 |       INDEX UNIQUE SCAN        | DID_VENDOR_BATCHES_PK  |     1 |       |     0   (0)| 00:00:01 |
  19. |  15 |      TABLE ACCESS BY INDEX ROWID   | DID_VENDOR_BATCHES     |     1 |    25 |     1   (0)| 00:00:01 |
  20. -------------------------------------------------------------------------------------------------------------
  21.  
  22. Predicate Information (identified by operation id):
  23. ---------------------------------------------------
  24.  
  25.    1 - filter("RNUM1">1)
  26.    2 - filter(ROWNUM<=11)
  27.    9 - access("N"."I_ENV"=114)
  28.   11 - access("N"."I_DO_BATCH"="O"."I_DO_BATCH"(+))
  29.   13 - access("A"."I_ENV"(+)=114 AND NLSSORT("ID"(+),'nls_sort=''BINARY_CI''')=NLSSORT("number",'nls_
  30.           sort=''BINARY_CI'''))
  31.   14 - access("N"."I_DV_BATCH"="V"."I_DV_BATCH")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top