Re: Inefficient query plan using large in-list
From: S M <xt.and.r_at_gmail.com>
Date: Thu, 16 May 2019 18:56:23 +0300
Message-ID: <CAOVevU7rSNRSg9F3m_513rV7xegWn+r=Vu7gNd1EDmTiu1KU0A_at_mail.gmail.com>
Date: Thu, 16 May 2019 18:56:23 +0300
Message-ID: <CAOVevU7rSNRSg9F3m_513rV7xegWn+r=Vu7gNd1EDmTiu1KU0A_at_mail.gmail.com>
Hi Senthil,
That is well-known table functions(kokbf$-) limitations: they block such transformations. You can google about it, there are few standard solutions(precompute_subquery hint, laterals, etc...), but the best one is to avoid table functions in such complex queries.
On Thu, May 16, 2019 at 6:44 PM Senthil Subramanian <skumar.sen_at_gmail.com> wrote:
>
> from table(cast(multiset(select level from dual
>
>
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 16 2019 - 17:56:23 CEST