Re: Sanity Check - Correlated Select Subquery SQL rewrite equivalent? Or no?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 1 Feb 2023 11:41:41 -0500
Message-ID: <4c0f1b49-7605-7b4d-1567-b072a749081e_at_gmail.com>
Date: Wed, 1 Feb 2023 11:41:41 -0500
Message-ID: <4c0f1b49-7605-7b4d-1567-b072a749081e_at_gmail.com>
On 2/1/23 11:19, Clay Jackson (Clay.Jackson) wrote:
>
> What Dominic said –
>
> Among other things –
>
> where FPE.COL3 = T1.COL3
>
> is NOT part of the predicate in the original query
>
Not only that, the 2nd query doesn't have MAX function in it, thereby
being definitely not equivalent. I would probably try to separate the
subquery into a WITH clause, materialize and do join.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 01 2023 - 17:41:41 CET