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