- You can find an overview of the scripts used during the Webinar in the "Notes" section on the first slide of the Powerpoint presentation - The same section also lists various links to blog posts that are helpful and have been mentioned during the Webinar Clustering Factor Demo: concurrent_execution_inserts_testcase.sql, concurrent_execution_inserts_check_results.sql Frequency Histogram Demo: frequency_histogram_egde_case.sql Height Balanced Histogram Demo: histogram_limitations_testcase.sql Daft Datatypes Demo: daft_data_type_example.sql Implicit Datatype Conversion Demo: implicit_datatype_conversion_nvarchar_scratchpad.sql AllThingsOracle.com: http://allthingsoracle.com/author/randolf-geist/ Blog post “What-If Analysis Clustering Factor”: http://oracle-randolf.blogspot.de/2010/01/clusteringfactor-what-if-analysis.html Blog posts “Fake Histograms”: http://jonathanlewis.wordpress.com/2010/03/23/fake-histograms/ http://jonathanlewis.wordpress.com/2009/05/28/frequency-histograms/ Limitations of histograms: http://oracle-randolf.blogspot.de/2009/01/limitations-of-histograms-rounding.html Successful Dynamic Sampling on rare / clustered values: http://allthingsoracle.com/dynamic-sampling-iii-real-life-data-part-ii/ Further links to address questions that popped up during the Q&A: 10g to 11g Upgrade: What to expect from the Optimizer: https://blogs.oracle.com/optimizer/entry/what_happened_to_the_optimizer_white_papers_on_otn Gathering statistics on partitioned tables: http://jonathanlewis.wordpress.com/2010/03/17/partition-stats/ http://oracledoug.com/serendipity/index.php?/archives/1590-Statistics-on-Partitioned-Tables-Contents.html Some notes on the limitations of Adaptive Cursor Sharing, that was introduced in 11g to address the problems of Bind Variable Peeking and shared cursors (histograms are one popular threat in that category): http://oracle-randolf.blogspot.com/2011/01/adaptive-cursor-sharing.html