Useful Metalink Notes for Query Tuning and Optimizations

1. How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
2. TROUBLESHOOTING: Tuning a New Query (Doc ID 372431.1)
3. TKPROF Basic Overview (Doc ID 41634.1)
4. SQL Tuning Health-Check Script (SQLHC) (Doc ID 1366133.1)
5. TKProf Interpretation (9i and above) (Doc ID 760786.1)
6. Interpreting Raw SQL_TRACE output (Doc ID 39817.1)
7. Diagnosing and Understanding Why a Query is Not Using an Index (Doc ID 67522.1)
8. Why is my Hint Ignored? (Doc ID 69992.1)
9. Optimizing statements that contain views or subqueries (Doc ID 199070.1)
10. Optimization of Large Inlists / Multiple OR Conditions (Doc ID 62153.1)
11. Troubleshooting a Server Upgrade Resulting in Slow Query Performance (Doc ID 160089.1)
12. Diagnosing and Understanding Why a Query is Not Using an Index (Doc ID 67522.1)