I should have time to do some testing next week. I hope to prune the query down
quite a bit to make it simpler/more legible. I do have both execution plans
though I had use EXPLAIN PLAN to get the 12.2 one as the query never completed.
They are similar but not identical.
Fortunately since optimizer_features_enable is settable on the session level it
will be easy to test.
Sr. Oracle DBA
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Andy Sayer
Sent: Friday, August 10, 2018 3:06 PM
Subject: Re: 12.2 bug for ANSI outer join syntax
Left outer joins to subqueries are common, are you sure the scenario is as
simple as that?
Was there an execution plan? Perhaps the optimizer had correlated the subquery
whereas that needs to not happen for your query performance to be acceptable
(or vice versa).
Have you got an end-to-end demo you can share?