Re: Re: The wonder of increasing rows

Hi Saysan,
what kind of Index statistics would be used to calculate cardinaliy? Regards
Lothar
----Ursprüngliche Nachricht----
Von : xt.and.r_at_gmail.com
Datum : 28/10/2019 - 12:04 (MN)
An : l.flatz_at_bluewin.ch
Cc : oracle-l_at_freelists.org
Betreff : Re: The wonder of increasing rows  

  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:17:36 CET