Re: Join Cardinality

From: Patrick Jolliffe <jolliffe_at_gmail.com>
Date: Fri, 31 May 2019 19:03:51 +0800
Message-ID: <CABx0cSV+HRro5BaYAsgjpqHNCx8nnyd+AKR-PGJAW5gkbtPXkQ_at_mail.gmail.com>



Thanks both, let me try and follow up over the weekend. Stefan,
Maybe it's cos I'm tired, but I could see the SWRU referenced and used throughout the paper, but I couldn't actually find the definition of the SWRU function,
Am I missing something?
Patrick

On Fri, 31 May 2019 at 18:59, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> 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 - 13:03:51 CEST

Original text of this message