Just a quick post here so I could consolidate some information about histograms in 12c.
On my last Office Hours session, one of the questions that was posed was asking for an explanation of the new types of histograms in use in 12c. So I had a few slides and described conceptually at a high level how they work and what they represent. If you’re new to 12c, or new to optimizer histograms in general, then take a look at the video below to get up to speed. But for those who want to dig into a deeper level, I also saw recently two absolutely cracking articles which discuss the algorithms and implementation in much more detail. So I’ve linked them here as well.
http://www.oracle.com/technetwork/articles/database/histogram-construction-oracle-12c-4426845.html
http://www.oracle.com/technetwork/articles/database/maintenance-histograms-db-12c-4426850.html
On that note…if you celebrate Easter – have a safe and happy break. So you on the other side of the weekend!
Recent comments
1 year 3 weeks ago
1 year 16 weeks ago
1 year 20 weeks ago
1 year 21 weeks ago
1 year 25 weeks ago
1 year 47 weeks ago
2 years 15 weeks ago
2 years 44 weeks ago
3 years 29 weeks ago
3 years 29 weeks ago