MISSION 260

Using an Index

Learn about how Postgres accesses data and how to use indexes to speed this up

Objectives

  • Learn how an index speeds up common queries.
  • Learn how to build an index table.
  • Learn how to benchmark query speeds.

Mission Outline

1. Alternate Table Scans
2. Index Scan
3. Time Complexity
4. Indexing
5. Comparing the Queries
6. Create an Index
7. Dropping Indexes
8. Index Performance on Joins
9. Next Steps
10. Takeaways

optimizing-postgres-databases-data-engineering

Course Info:

Optimizing Postgres Databases

Intermediate

The average completion time for this course is 10-hours.

This course is free and includes five missions. It is the 2nd course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside