Articles tagged TOP-frequency

19 January 2016
19 January 2016

12c Histogram: TOP-Frequency

As of Oracle version 12.1, if a number of buckets N in a histogram is less than the number of distinct values in the data set, Oracle will not generate the instable and imprecise legacy Height Balanced histogram. Instead, two new types of histogram are possible: TOP-Frequency and Hybrid. In order to select between the later and the former ty… Read more