- SELECT
FROM (SELECT id FROM ... LIMIT 0,10) - Subqueries not the silver bullet
- Often not cached or indexed
- Views help manage complex relationships but not performance
- Changing picture
- Even between MySQL 5.0 and 5.1
- MySQL 6.0
- Falcon (transactional) Storage
- Better subquery optimisation
In Focus
3.6.13. Optimise (Delayed Joins)