Databases Demystified Lesson 10: Query Planning and Optimization
In this lesson, we talk about what a query planner is and does in the database. We talk about the difference between declarative and imperative programming languages, and we wrap up with a discussion of some common strategies for database optimization to improve query speed.