SQL Performance (MOSC)

MOSC Banner

Discrepancy in Explain Plan Rows and Select stmt processed rows

edited Jun 1, 2017 5:01AM in SQL Performance (MOSC) 3 commentsAnswered

I run this below sql statement, plan attached. As per the explain plan Am i not supposed to get just 4 records? I am seeing 409 records returned. Any ideas?

SQL>    SELECT  DISTINCT

  2             T.PER_ID,

  3  --         PS.PRICEASSIGNMENTID,

  4             T.START_DT,

  5             T.END_DT,

  6  --                 CASE

  7  --                         WHEN TRIM (Y.HCCLIST) IN ('HT', 'MH') THEN 'MD'

  8  --                 ELSE TRIM (Y.HCCLIST)

  9  --                 END

10  --         AS HCCLIST,

11  --         Z.PRODUCTCODE,

12             T.BUS_OBJ_CD,

13             T.PRICEITEM_CD,

14  --         ST.LASER_AMT,

15             XMLTYPE (BO_DATA_AREA).EXTRACT ('/extendedData//CM_MAX_RUN_IN_AMT/text()').getstringval () AS CM_MAX_RUN_IN_AMT,

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