EXPLAIN the filter query plan step
All Olympic athletes are impressive, but athletes that are not yet adults (i.e., too young to drive or vote) are particularly impressive. You will look at these young athletes, those under 16 years, for African athletes across all Winter Olympics.
Before proceeding, feel free to explore the athletes_wint
table and find if any athletes are your age.
Once done exploring, you will use the EXPLAIN
function to see how your WHERE
clause executes.
This exercise is part of the course
Improving Query Performance in PostgreSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT ___
FROM athletes_wint
WHERE ___ < ___;