Merge Join Cartesian
From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Wed, 10 Jan 2024 16:29:52 -0500
Message-ID: <CAG67e6SoVi7gqUfORZv+16m4W5e90JuYZ4YDuuQDEzdvfbW17A_at_mail.gmail.com>
Hi All,
Date: Wed, 10 Jan 2024 16:29:52 -0500
Message-ID: <CAG67e6SoVi7gqUfORZv+16m4W5e90JuYZ4YDuuQDEzdvfbW17A_at_mail.gmail.com>
Hi All,
I've noticed a lot of queries in our environment that use Merge Join Cartesian instead of Hash Join or Nested Loop Joins, which seems unusual to me. Could you please let me know if you've noticed anything similar and what the cause might be?
Thank you in advance for your assistance and support.
Best Regards,
AMIT
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 10 2024 - 22:29:52 CET