Re: 12c row limiting clause woes
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 5 Sep 2016 12:29:25 +0300
Message-ID: <CAOVevU6uAf5h00P6_=uafDmYicSyypOb646iF3yQp5jk4mv4eQ_at_mail.gmail.com>
Date: Mon, 5 Sep 2016 12:29:25 +0300
Message-ID: <CAOVevU6uAf5h00P6_=uafDmYicSyypOb646iF3yQp5jk4mv4eQ_at_mail.gmail.com>
Hi Mike,
Oracle will use index if you add "alter table foo modify a not null;". About cardinality: strictly speaking, since row limiting clause is syntactic sugar for analytic functions, it has even more problems than just analytic functions.
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 05 2016 - 11:29:25 CEST