QUERY AND APPLICATION TUNING USING EXPLAIN AND TKPROF UTILITY
INDEX STATISTICS
USING 'EXPLAIN PLAN': SUBQUERIES IN UPDATE STATEMENTS
QUERY PATHS RANKED IN ORDER OF SPEED
INDEX SELECTION: THE OPTIMIZER REVEALED
UPDATE PERFORMANCE
V7. PERFORMANCE TUNING WITH BSTAT/ESTAT
Index Space Usage
Determining the execution plan for a distributed query
Cost Based Optimizer - Common Misconceptions and Problems