SQL Performance (MOSC)

MOSC Banner

not null filter

edited Aug 16, 2016 4:20PM in SQL Performance (MOSC) 3 commentsAnswered ✓

I have a simple sql, looking at the predicate information from the dbms_xplan

I have on the first position the top position filter( IS NULL).

I get the is null part but uncertain why I do not see a column reference,

I expect to see a column there .

Is this an error from dbms_xplan or what does this tell me ?

Appreciate if anyone can explain it to me...

SELECT A.row_id       FROM   siebel.s_org_ext A,

siebel.s_org_ext_xm C       WHERE  A.x_pr_comp_code_argus NOT IN

(SELECT row_id                                             FROM

siebel.s_org_ext_xm COM1

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