What does it means the letter U in the predicate information about display_cursor?
Hi all,
I've an issue, difficult to understand!
I checked the plan of a query with DBMS_XPLAN.DISPLAY_CURSOR, the query:
SELECT I.REQPROCEDURECODE FROM IHE_ORDERS I, REPORT RP WHERE RP.STUDYINSTANCEUID = '1.2.826.0.1.3802357.101.121000002243' AND RP.FLGSTATE = 0 AND RP.REQPROCEDURECODE = I.REQPROCEDURECODE AND I.FLGSTATE=0;
and in the Predicate Information sector i found this:
Plan hash value: 2437945815
--------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 18016 (100)| |
|* 1 | HASH JOIN | | 546K| 63M| 18M| 18016 (1)| 00:03:37 |
|* 2 | TABLE ACCESS FULL | IHE_ORDERS | 546K| 12M| | 4749 (1)| 00:00:57 |
|* 3 | TABLE ACCESS BY INDEX ROWID| REPORT | 2226K| 205M| | 826 (1)| 00:00:10 |
|* 4 | INDEX RANGE SCAN | IX_REP_STUDYUID | 2232K| | | 25 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("RP"."REQPROCEDURECODE"="I"."REQPROCEDURECODE")
2 - filter("I"."FLGSTATE"=0)
0