This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August 2012.

You may want to watch Oracle Cost-Based Optimizer Basics before you view this video

Watch video

The video above is accompanied by the following downloadable resources:

• Read me
• Presentation slides – PDF version
• Presentation slides – PowerPoint version
• concurrent_execution_inserts_check_results.sql
• concurrent_execution_inserts_testcase.sql
• concurrent_execution_launch_slaves.sql
• daft_data_type_example.sql
• frequency_histogram_egde_case.sql
• histogram_limitations_testcase.sql
• implicit_datatype_conversion_nvarchar_scratchpad.sql
• insert_no_wait.sql
• xplan_extended_display_cursor.sql
• Download all resources (.zip)

Building on the previous Cost-Based Optimizer Basics webinar, in this almost “zero-slide” session we’ll explore different aspects of the Cost-Based Optimizer that haven’t been covered or only mentioned briefly in the ‘basics’ session.

This is a continuous live demonstration including topics like: Clustering Factor, Histograms, Dynamic Sampling, Virtual Columns, Daft Data Types and more. If you’ve ever asked yourself why a histogram can be a threat to database performance and why storing data using the correct data type matters regarding Execution Plans then this session is for you. It is recommended, although not required, to watch the recording of the ‘basics’ webinar first.

A live Q+A session with Randolf Geist follows the presentation.