SQL Performance (MOSC)

MOSC Banner

What does it means the letter U in the predicate information about display_cursor?

edited Nov 3, 2015 10:08AM in SQL Performance (MOSC) 5 commentsAnswered ✓

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)
  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center