Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- -------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 19683 | 384K| 3648 (2)| 00:00:01 |
- | 1 | TEMP TABLE TRANSFORMATION | | | | | |
- | 2 | LOAD AS SELECT | SYS_TEMP_0FD9FD2ED_ADA48C62 | | | | |
- | 3 | UNION-ALL | | | | | |
- | 4 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 5 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 6 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 7 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 8 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 9 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 10 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 11 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 12 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
- | 13 | SORT ORDER BY | | 19683 | 384K| 3648 (2)| 00:00:01 |
- | 14 | HASH UNIQUE | | 19683 | 384K| 3642 (2)| 00:00:01 |
- | 15 | CONCATENATION | | | | | |
- | 16 | MERGE JOIN CARTESIAN | | 6561 | 128K| 1658 (1)| 00:00:01 |
- | 17 | MERGE JOIN CARTESIAN | | 729 | 12393 | 197 (6)| 00:00:01 |
- |* 18 | HASH JOIN | | 81 | 1134 | 35 (29)| 00:00:01 |
- | 19 | MERGE JOIN CARTESIAN | | 81 | 486 | 20 (0)| 00:00:01 |
- | 20 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 21 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 22 | BUFFER SORT | | 9 | 27 | 20 (0)| 00:00:01 |
- | 23 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 24 | TABLE ACCESS STORAGE FULL| SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 25 | TABLE ACCESS STORAGE FULL | WORDS | 95907 | 749K| 11 (55)| 00:00:01 |
- | 26 | BUFFER SORT | | 9 | 27 | 186 (3)| 00:00:01 |
- | 27 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 28 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 29 | BUFFER SORT | | 9 | 27 | 1656 (1)| 00:00:01 |
- | 30 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 31 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 32 | MERGE JOIN CARTESIAN | | 328 | 6560 | 269 (4)| 00:00:01 |
- |* 33 | HASH JOIN | | 36 | 612 | 197 (6)| 00:00:01 |
- | 34 | MERGE JOIN CARTESIAN | | 729 | 6561 | 182 (0)| 00:00:01 |
- | 35 | MERGE JOIN CARTESIAN | | 81 | 486 | 20 (0)| 00:00:01 |
- | 36 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 37 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 38 | BUFFER SORT | | 9 | 27 | 20 (0)| 00:00:01 |
- | 39 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 40 | TABLE ACCESS STORAGE FULL| SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 41 | BUFFER SORT | | 9 | 27 | 180 (0)| 00:00:01 |
- | 42 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 43 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 44 | TABLE ACCESS STORAGE FULL | WORDS | 95907 | 749K| 11 (55)| 00:00:01 |
- | 45 | BUFFER SORT | | 9 | 27 | 258 (2)| 00:00:01 |
- | 46 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 47 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- |* 48 | HASH JOIN | | 16 | 320 | 1658 (1)| 00:00:01 |
- | 49 | MERGE JOIN CARTESIAN | | 6561 | 78732 | 1643 (1)| 00:00:01 |
- | 50 | MERGE JOIN CARTESIAN | | 729 | 6561 | 182 (0)| 00:00:01 |
- | 51 | MERGE JOIN CARTESIAN | | 81 | 486 | 20 (0)| 00:00:01 |
- | 52 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 53 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 54 | BUFFER SORT | | 9 | 27 | 20 (0)| 00:00:01 |
- | 55 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 56 | TABLE ACCESS STORAGE FULL| SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 57 | BUFFER SORT | | 9 | 27 | 180 (0)| 00:00:01 |
- | 58 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 59 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 60 | BUFFER SORT | | 9 | 27 | 1641 (1)| 00:00:01 |
- | 61 | VIEW | | 9 | 27 | 2 (0)| 00:00:01 |
- | 62 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9FD2ED_ADA48C62 | 9 | 27 | 2 (0)| 00:00:01 |
- | 63 | TABLE ACCESS STORAGE FULL | WORDS | 95907 | 749K| 11 (55)| 00:00:01 |
- -------------------------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 18 - access("WORDS"."WORD"="L1"."LT"||"L2"."LT")
- 33 - access("WORDS"."WORD"="L1"."LT"||"L2"."LT"||"L3"."LT")
- filter(LNNVL("WORDS"."WORD"="L1"."LT"||"L2"."LT"))
- 48 - access("WORDS"."WORD"="L1"."LT"||"L2"."LT"||"L3"."LT"||"L4"."LT")
- filter(LNNVL("WORDS"."WORD"="L1"."LT"||"L2"."LT"||"L3"."LT") AND
- LNNVL("WORDS"."WORD"="L1"."LT"||"L2"."LT"))
Add Comment
Please, Sign In to add comment