Re: 12.2 bug for ANSI outer join syntax
From: Andy Sayer <andysayer_at_gmail.com>
Date: Fri, 10 Aug 2018 20:05:54 +0100
Message-ID: <CACj1VR6t2NL_ekcezkkviko0ovTG5TgTvNRY59_o4HF0uKtNew_at_mail.gmail.com>
Date: Fri, 10 Aug 2018 20:05:54 +0100
Message-ID: <CACj1VR6t2NL_ekcezkkviko0ovTG5TgTvNRY59_o4HF0uKtNew_at_mail.gmail.com>
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,
Andy
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 10 2018 - 21:05:54 CEST