Re: Query Performance issue
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 29 Dec 2020 11:59:35 -0500
Message-ID: <8dbc14ee-b13c-f5fd-42b4-d82197baee41_at_gmail.com>
Date: Tue, 29 Dec 2020 11:59:35 -0500
Message-ID: <8dbc14ee-b13c-f5fd-42b4-d82197baee41_at_gmail.com>
If Oracle 18c or newer is used, it is possible to use local temporary tables instead. The snag is that local temporary tables cannot be indexed.
On 12/28/20 4:47 PM, Mark W. Farnham wrote:
> One technique is to decompose each row source to the relevant rowids
> and use those rowids to populate a gtt from each base table with just
> the columns you need for the final projection. It is usually possible
> to do that in a “WITH” clause, or you can instantiate the gtt in the
> session.
-- Mladen Gogala Database Consultant http://mgogala.byethost5.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 29 2020 - 17:59:35 CET