In this tutorial you will use SQL Developer to generate and display the explain plan of a SQL query and execute an autotrace plan. In addition, you examine the effects of changing column order in a composite index and use SQL Plan Baseline to associate a hinted execution plan with a hard coded SQL statement.
Duration: 40 minutes
Release Date: 12-MAR-2013
This set of OBEs shows you how to use SQL Developer to find tuning information.
Release Date: 15-AUG-10