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>
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-lReceived on Fri May 31 2019 - 13:03:51 CEST