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,
Received on Mon Oct 04 2021 - 21:14:07 CEST
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)
Thank you.
--
http://www.freelists.org/webpage/oracle-l
- application/octet-stream attachment: hj_10053.sql