Re: Join Cardinality

  • From: Patrick Jolliffe <jolliffe@xxxxxxxxx>
  • To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • Date: Fri, 31 May 2019 19:03:51 +0800

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@xxxxxxxxx> 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

Other related posts: