Re: Inefficient query plan using large in-list

From: S M <>
Date: Thu, 16 May 2019 18:56:23 +0300
Message-ID: <>

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 <> wrote:

> from table(cast(multiset(select level from dual

Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate

Received on Thu May 16 2019 - 17:56:23 CEST

Original text of this message