Re: Join Cardinality
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 31 May 2019 13:58:02 +0300
Message-ID: <CAOVevU5Vss2jXD2u5tZXLVMS5pNnkqSihJ9t8MA+WXMehcz20Q_at_mail.gmail.com>
Date: Fri, 31 May 2019 13:58:02 +0300
Message-ID: <CAOVevU5Vss2jXD2u5tZXLVMS5pNnkqSihJ9t8MA+WXMehcz20Q_at_mail.gmail.com>
Hi Patrick,
JSEL should be 1/50, since you already filtered T1 ("T1"."RAND20"=1) and
got 50 rows
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 31 2019 - 12:58:02 CEST