A new white paper for SQL Plan Management is now available. Just go to the Query Optimization page in OTN
and click the SQL Plan Management with Oracle Database 12c
Just like the Optimizer white paper, I've kept the content and format similar to the way Maria organized
it so that it will be familiar to those of you that have read previous versions.
Post comments to this blog if you want to give me feedback on the
white paper's content. If you want more examples, let me know and I'll
add suggestions to my to-do list.
All the white papers referenced
in the Optimizer page are being updated, so expect to see more soon.
This post covers how you can manage optimizer statistics efficiently when you use partition exchange load (PEL). This technique is used when large volumes of data must be loaded and maximum performance is paramount. It’s common to see it used in decision support systems and large operational data stores.
Make sure you’ve taken a look at Part 1, or you are at least familiar with the concept of incremental statistics so that you know what a synopsis is in the context of a partitioned table.