Query Tuning

• Is it the query you want? (design)
   
• Is it doing what you want? (results)
   
• Is it "close enough" to the real query?
   
• EXPLAIN and EXPLAIN ANALYZE
   
• Other ways to measure speed: logging, application, \timing

Previous: Database Design         [Table of Contents]         Next: Faster