Re: The wonder of increasing rows

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: l.flatz@xxxxxxxxxx
  • Date: Mon, 28 Oct 2019 14:04:01 +0300

Hi Lothar,

For index access row-sources (rows 3-4 of the first plan) CBO calculates
cardinality using index statistics, and for table access it uses table
statistics.

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

Other related posts: