File Library

Since its inception in 2008, the Exadata platform has evolved from a balance hardware configuration for Data Warehouse environments to the platform of choice for all database applications. With each new release Exadata has introduced key performance enhancing features such as query offload, storage indexes, flash cache, and Hybrid Columnar Compression. Knowing when and how to take advantage of each of these features can be a daunting task even for the Oracle Optimizer, whose goal has always been to find the optimal execution plan for every SQL statement. This session explains in detail how the Oracle Optimizer costing model has been impacted by the introduction of the performance enhancing feature of the Exadata platform. It will show through the use of real-world examples what you can do to ensure the Optimizer full understands the capabilities of the platform it is running on without having to mess with initialization parameters or Optimizer hints.