Re: Query Performance issue

From: Mladen Gogala <>
Date: Tue, 29 Dec 2020 11:59:35 -0500
Message-ID: <>

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

Received on Tue Dec 29 2020 - 17:59:35 CET

Original text of this message