Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Hybrid histograms
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!
Hello Connor,
Thanks a lot for this last excellent Asktom Office Hours session 🙂
Happy Easter and enjoy preparing the upcoming sessions 🙂
Cheers & Best Regards,
Iudith Mentzel