Does this an Oracle Optimizer malfunction?
I have a query oo a view like this:
SELECT
SQN,REC_BDTS,SAT_LDTS,SAT_RSRC,SAT_FREQ,REC_EDTS,REC_CRNT_IND,REC_PURGE_IND,TYPE_CD FROM N_IZ6ARD_2_S_TYPES_V
;
Oracle will use NESTED LOOPS OUTER to perform the JOIN.
but once I put "--" in the query like this
SELECT
SQN
--
,REC_BDTS,SAT_LDTS,SAT_RSRC,SAT_FREQ,REC_EDTS,REC_CRNT_IND,REC_PURGE_IND,TYPE_CD FROM N_IZ6ARD_2_S_TYPES_V
;
Oracle will use HASHED LOOPS OUTER to perform the JOIN which performance is much better. And also this is the right execution plan.