Re: Query Performance issue

Lothar,

Almost certainly the case, but probably more complicated than a sufficiently efficient, but simple(r), rewrite.

Regards
Jonathan Lewis

On Tue, 29 Dec 2020 at 12:21, Lothar Flatz <l.flatz_at_bluewin.ch> wrote:

> Hi Mark,
>
> I wonder if Björn and mine "backbone join" technique can be used.
> Stefan describes it in short here:
>
> https://community.oracle.com/tech/apps-infra/discussion/4386851/implement-index-backbone-join-transformation-rewrite-in-cbo-code
>
> The bottom line is to rewrite the query such that the join is made only
> with the columns essentially needed.
> In my example you need to put essential columns into indexes. On an
> Exadata that might not even be necessary.
> The rest of the columns is picked up later using the rowids of the rows
> that make it into the final result.
>
> Regards
>
> Lothar
>
>

--
http://www.freelists.org/webpage/oracle-l