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