# Objectives
+ Control execution plans with optimizer hints
+ Control execution plans with SQL Plan Management (SPM)
+ Understand the best practices for writing effective SQL and using indexes
+ Understand subquery optimizations
------------------------------------------------------------------------------
[no notes]