Re: The wonder of increasing rows

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 28 Oct 2019 14:04:01 +0300
Message-ID: <CAOVevU7npyG9_UwF5mO29jScTTTmiUpP1oOddWEMUpir1gXw=A_at_mail.gmail.com>



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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 28 2019 - 12:04:01 CET

Original text of this message