Weekend Learning: Optimizer Filter Push Down

Are you trying to learn more about the Optimizer and how it can make decisions for predicates?  Then you may want to check out this document on My Oracle Support "Optimizer Filter Push Down" via article ID 1082122.1 to learn a bit more for your toolbox!

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!

Blooming onions or bloom filters?

Another great article from the experts at Pythian, this time from Christo Kutrovsky, about join offloading and bloom filters with links to some articles on storage indexes and predicate filtering that I need to read in some detail as well.  If you're interested in any of this for Exadata, visit the article and read/click through because it is a really well thought out and presented write up on the topic.

I did learn something about the "cell_flash_cache keep" attribute for tables and the PX_JOIN_FILTER optimizer hint available to force the CBO to use join offloading; both of which I've never used, or seen used, so I feel like I got my money's worth (isn't it awesome that blogs are free?) especially if I can pass this along to some of our developers to help expand their awareness as well