Showing posts with label Jonathan Lewis. Show all posts
Showing posts with label Jonathan Lewis. Show all posts
Wednesday, October 8, 2014
Jonathan Lewis: Execution Plans
Are you interested in learning more about how the Optimizer works, how to walk through execution plans, or even how to generate your own plans? Look no further than Jonathan Lewis's excellent series on execution plans courtesy of redgate and AllThingsOracle! So far there are 10 posts, and you will probably learn something from each and every post of his!
Wednesday, September 11, 2013
12c September - Jonathan Lewis
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.
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.
Subscribe to:
Posts (Atom)