Oracle Scratchpad

September 1, 2013

Histograms

Filed under: Histograms,Oracle,Statistics — Jonathan Lewis @ 9:41 am GMT Sep 1,2013

A three-part series on histograms up to and including 11g – written for Allthings Oracle. With Chinese transalation:

And a three part series on histograms in 12c on this blog

A short video recorded at RMOUG 2013 about the improvements in Oracle’s histogram mechanisms as you upgrade from 11g to 12c.

Update (Jan 2016):

A pair of articles by Mohamed Houri, published on allthingsoracle.com adding discussing details of the mechanisms and selectivity calculations for 12c histograms:

 

 

1 Comment

  1. Part three has just been published on AllThingOracle (Link in the article).

    Comment by Jonathan Lewis — October 16, 2013 @ 5:17 pm GMT Oct 16,2013


RSS feed for comments on this post.

Blog at WordPress.com.