Jonathan Lewis deserves his own week-long blog spotlight, but until I do that, he gets a mini-spotlight today on several 12c related articles he's written lately!
Here he investigates the differences between 11g and 12c where a new type called "Top-N" is being introduced, in part two he compares simple frequency histograms and Top-N histograms (and goes quite a bit above my head), then he compares some previous histogram issues to explore if they have been resolved with 12c.
In 12c there are several changes to subquery factoring that he shares, and also details the changes to join views too!
While even though the title says "Manuals", this article has some interesting discussion in the comments about what the true maximum services per instance are versus what Oracle has documented.
No comments:
Post a Comment