1. Aprende
    2. /
  2. Cursos
    3. /
  3. Improving Query Performance in PostgreSQL
  • 1

    Bringing Together the Data

    Gratuito

    Bundle up as you dive into the Winter Olympics! You will learn how to join, subquery, and create temporary tables while finding which Olympic athletes brave sub-freezing temperatures to train. You will also learn about the query planner and how its functionality can guide your SQL structure to faster queries.

  • 2

    Minimizing Results and Decreasing the Load

    Dig up those past algebra memories while learning the SQL order of operations. Find which countries "should" have the most athletes by looking at population and gross domestic product (GDP) while learning the best way to filter. You will also learn when your query aggregates (sums, counts, etc.) and how you can structure your query to optimize this process.

  • 3

    Using Database Designed Properties

    Zero in on the properties that improve database performance. Discover when your table is not a table but a view. Learn how your database's storage structure (row or column oriented) impacts your query structure. You will explore volcanic smog while using partitions and indexes to speed your queries.

  • 4

    Assessing Query Performance

    Learn the lingo of the Query Lifecycle and dive into the query planner. Explore how the query planner creates and optimizes the query plan. Find your next vacation locale by looking for countries with recent population growth while also seeing how a join impacts the query steps. Fine tune your optimization techniques by seeing how different filters speed your query times.

Initializing

Ejercicio

Data type filters

Since the first African country participated in the Winter Olympics in 1960, only two preteen (11 and 12 years) athletes have participated. Both athletes competed in the 1960 games.

Perhaps athletes in the 21st century are now older when they compete. Take a quick look at the oldest (1960) Winter games and compare it to the Winter games 50 years later (2010) to test this hypothesis.

Instrucciones 1/2

undefined XP
  • 1

    Filter the table to the two relevant Winter Olympics, the 1960 Winter and 2010 Winter games .

  • 2

    Optimize that query by changing to the numeric year filter.