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:

Intermediate

The median completion time for this course is 4.7 hours. ​View Details​​​

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

START LEARNING FREE

Take a Look Inside