RE: 12.2 bug for ANSI outer join syntax
Date: Fri, 10 Aug 2018 20:50:36 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F754849EE1_at_PRDCTWPEMLMB31.prod-am.ameritrade.com>
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.
Jay Miller
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Sayer
Sent: Friday, August 10, 2018 3:06 PM
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?
Regards,
Sr. Oracle DBA
201.369.8355
To: dmarc-noreply_at_freelists.org
Cc: oracle-l_at_freelists.org
Subject: Re: 12.2 bug for ANSI outer join syntax
Andy
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 10 2018 - 22:50:36 CEST