Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Typical SQL Optimization Methods
Experience in Rewriting SQL Statements
Adjusting Key Parameters During SQL Tuning
Hint-based Tuning
Routinely Maintaining Tables
Routinely Recreating an Index
Configuring the SMP