1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in PostgreSQL

Exercise

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.

Instructions 1/2

undefined XP
    1
    2

Use age to find all the records with athletes less than 16 years old.