By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 2450448547 |
------------------------------------------------------------------------------------ |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
------------------------------------------------------------------------------------ |
| 0 | SELECT STATEMENT | | 1 | 336 | 5 (20)| 00:00:01 | |
|* 1 | FILTER | | | | | | |
|* 2 | HASH JOIN OUTER | | 1 | 336 | 5 (20)| 00:00:01 | |
| 3 | TABLE ACCESS FULL| REQUEST_INFO | 1 | 26 | 2 (0)| 00:00:01 | |
| 4 | TABLE ACCESS FULL| TEST_DATA | 1 | 310 | 2 (0)| 00:00:01 | |
------------------------------------------------------------------------------------ |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
1 - filter(UPPER(COALESCE("TD"."SUPPL_FORMATTED_RESULT","TD"."FORMATTED_R |
ESULT"))='491(10)376' AND COALESCE("TD"."SUPPL_IDNUM","TD"."IDNUM")=40549) |
2 - access("TD"."SEQ_NUMBER"(+)="RI"."SEQ_NUMBER" AND |
"TD"."LAB_NUMBER"(+)="RI"."LAB_NUMBER") |
Note |
----- |
- dynamic sampling used for this statement (level=2) |
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 1684531989 |
---------------------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
---------------------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | 1 | 194 | 1 (0)| 00:00:01 | |
| 1 | NESTED LOOPS | | 1 | 194 | 1 (0)| 00:00:01 | |
| 2 | INDEX FULL SCAN | RI_SN_LN | 1 | 26 | 1 (0)| 00:00:01 | |
|* 3 | INDEX RANGE SCAN| TD_CUFR_CIDN_SN_LN | 1 | 168 | 0 (0)| 00:00:01 | |
---------------------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
3 - access(UPPER(COALESCE("SUPPL_FORMATTED_RESULT","FORMATTED_RESULT"))='491( |
10)376' AND COALESCE("SUPPL_IDNUM","IDNUM")=40549 AND |
"TD"."SEQ_NUMBER"="RI"."SEQ_NUMBER" AND "TD"."LAB_NUMBER"="RI"."LAB_NUMBER") |
filter("TD"."LAB_NUMBER" IS NOT NULL) |
Note |
----- |
- dynamic sampling used for this statement (level=2) |
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 865752842 |
---------------------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
---------------------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | 1 | 207 | 0 (0)| 00:00:01 | |
| 1 | NESTED LOOPS | | 1 | 207 | 0 (0)| 00:00:01 | |
|* 2 | INDEX RANGE SCAN| TD_CUFR_CIDN_SN_LN | 1 | | 0 (0)| 00:00:01 | |
|* 3 | INDEX RANGE SCAN| RI_SN_LN | 1 | 26 | 0 (0)| 00:00:01 | |
---------------------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
2 - access(UPPER(COALESCE("SUPPL_FORMATTED_RESULT","FORMATTED_RESULT"))='491( |
10)376' AND COALESCE("SUPPL_IDNUM","IDNUM")=40549) |
3 - access("TD"."SEQ_NUMBER"="RI"."SEQ_NUMBER" AND |
"TD"."LAB_NUMBER"="RI"."LAB_NUMBER") |
Note |
----- |
- dynamic sampling used for this statement (level=2) |
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 2450448547 |
------------------------------------------------------------------------------------ |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
------------------------------------------------------------------------------------ |
| 0 | SELECT STATEMENT | | 1 | 336 | 5 (20)| 00:00:01 | |
|* 1 | FILTER | | | | | | |
|* 2 | HASH JOIN OUTER | | 1 | 336 | 5 (20)| 00:00:01 | |
| 3 | TABLE ACCESS FULL| REQUEST_INFO | 1 | 26 | 2 (0)| 00:00:01 | |
| 4 | TABLE ACCESS FULL| TEST_DATA | 1 | 310 | 2 (0)| 00:00:01 | |
------------------------------------------------------------------------------------ |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
1 - filter(UPPER(COALESCE("TD"."SUPPL_FORMATTED_RESULT","TD"."FORMATTED_R |
ESULT"))='491(10)376' AND COALESCE("TD"."SUPPL_IDNUM","TD"."IDNUM")=40549 |
AND ("TD"."LAB_NUMBER" IS NOT NULL OR "TD"."SEQ_NUMBER" IS NOT NULL)) |
2 - access("TD"."SEQ_NUMBER"(+)="RI"."SEQ_NUMBER" AND |
"TD"."LAB_NUMBER"(+)="RI"."LAB_NUMBER") |
Note |
----- |
- dynamic sampling used for this statement (level=2) |