Performance Tuning
Hands-on tutorial
01 / THE CONCEPT
Understand the idea
In this lesson, explore performance tuning. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.
02 / SQL EXAMPLE
◉ example.sqlSQL
EXPLAIN QUERY PLAN SELECT * FROM students WHERE city='Baghdad';Try in SQL Lab ↗03 / KNOWLEDGE CHECK
Check your understanding
Which statement best describes performance tuning?