Re: Merge Join Cartesian
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 10 Jan 2024 17:42:31 -0500
Message-ID: <d527f498-e7b4-465b-b407-d15b23389897_at_gmail.com>
Date: Wed, 10 Jan 2024 17:42:31 -0500
Message-ID: <d527f498-e7b4-465b-b407-d15b23389897_at_gmail.com>
On 1/10/24 16:29, Amit Saroha wrote:
> 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
What has happened to the last statistics run? CBO might have decided
that your statistics is stale and refused to use the stats. You can
check in DBA_TAB_STATISTICS.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 10 2024 - 23:42:31 CET