Re: 12c row limiting clause woes

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: woodwardinformatics@xxxxxxxxxxxxxxxx
  • Date: Mon, 5 Sep 2016 12:29:25 +0300

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

Other related posts: