add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
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)