Query Optimizer
• Smarter use of indexes
• InnoDB prefers indexes more often
• Some ORDER BY queries don’t require
filesort
– Multi-column indexes
– Descending sorts