Oct 16: Air Database, Indexes

Learning Objectives

After today's class, you should be able to:

• Become familiar with and execute queries on the postgres_air database.
• Explain how to create SQL indexes and analyze query performance.

Lesson Outline

• [10 min] Introduction to HW4
• [30 min] Queries on the "air" database
• [35 min] Indexes and Query Optimizer

Your To-Do List

• Do most of HW4 – at a minimum, complete Parts 1–3 and get a good start on Part 4 before Tuesday
• Plan how you are going to fill your project database with data – real data, fake data, or a mix of both?