SQL Optimization

Introduction
1.1 Identifying SQL to optimize
1.2 Tuning strategies

Optimizer operation
2.1 Analyzing and processing a query
2.2 Query transformer
2.3 Transformer operations
2.4 Selectivity and cardinality
2.5 Calculating the cost of a query
2.6 Adaptive query optimization
2.7 Controlling optimizer behavior

Execution plans
3.1 Displaying execution plans
3.2 Reviewing execution plans
3.3 Using EXPLAIN PLAN
3.4 EXPLAIN PLAN options
3.5 Using AUTOTRACE
3.6 Performance views
3.7 Monitoring SQL

Interpreting execution plans
4.1 How to read an execution plan
4.2 Table operations
4.3 Index operations
4.4 Join operations
4.5 Other operations

Result caching
5.1 Introduction to RESULT_CACHE
5.2 Enabling RESULT_CACHE RESULT_CACHE
5.3 Using RESULT_CACHE

Optimizer Statistics
6.1 Importance of Statistics
6.2 Calculating and Configuring Statistics Calculation
6.3 Histograms and Histogram Calculation

Using BIND Variables
7.1 Cursor Sharing Concept
7.2 Using BIND Variables for Cursor Sharing

Application Trace
8.1 Using TKPROF
8.2 Using TRCSESS

Best Practices with SQL
9.1 Examples of Good and Bad Practices
9.2 Recommended SQL
9.3 Automatic Transformations