Discrepancy in Explain Plan Rows and Select stmt processed rows
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,