hash join cardinality missestimate

From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Mon, 4 Oct 2021 22:14:07 +0300
Message-ID: <CA+riqSW9GnkZbwM0hqhV=0C--fo-ZySg+jz2=besgs7MibkYpQ_at_mail.gmail.com>

Hello,

I have a big cardinality misestimate for a HJ operation: Join cardinality for HJ/SMJ (no post filters): 28073805.777726, outer: 42.720832, inner: 7801742.651163, sel: 2.1058e-04 Join Card - Rounded: 70185 Computed: 70184.514444

Can someone help me understand how optimizer came with that sel value? (attached 10053 extract)

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




application/octet-stream attachment: hj_10053.sql

Received on Mon Oct 04 2021 - 21:14:07 CEST

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: hash join cardinality missestimate"
Previous message: niall.litchfield_at_gmail.com: "Re: sys_guid()"
Next in thread: Jonathan Lewis: "Re: hash join cardinality missestimate"
Reply: Jonathan Lewis: "Re: hash join cardinality missestimate"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message