Oracle 19c Automatic Indexing: Data Skew Part II (Everything’s Alright)

Richard Foote's picture

In my previous post, I discussed an example with data skew, in which the Automatic Indexing process created a new index, but somehow the CBO when using the index estimated the correct cardinality estimate even though no histograms were explicitly calculated. In this post I’ll answer HOW this achieved by the CBO. Get some idea […]

To prevent automated spam submissions leave this field empty.