Re: Inefficient query plan using large in-list
From: Andy Sayer <andysayer_at_gmail.com>
Date: Thu, 16 May 2019 18:09:01 +0100
Message-ID: <CACj1VR7b=wHowVCmJ=vVgeJ80HKvnhQdZg6=8d8cU8r3AKq=cQ_at_mail.gmail.com>
Date: Thu, 16 May 2019 18:09:01 +0100
Message-ID: <CACj1VR7b=wHowVCmJ=vVgeJ80HKvnhQdZg6=8d8cU8r3AKq=cQ_at_mail.gmail.com>
“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)
Thanks,
Andy
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 16 2019 - 19:09:01 CEST