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>



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-l
Received on Thu May 16 2019 - 17:56:23 CEST

Original text of this message