Re: Inefficient query plan using large in-list

From: Andy Sayer <>
Date: Thu, 16 May 2019 18:09:01 +0100
Message-ID: <>

“2. Undocumented hint "materialize": you can hide your table() function in "with" clause with this hint ”
That won’t help, no matter where the table() function is in the query, the transformation is completely turned off.

Inserting into a GTT would be my preference (and get some proper stats on it)


Received on Thu May 16 2019 - 19:09:01 CEST

Original text of this message