MISSION 262

Advanced Indexing

Learn about advanced features of indexes such as multi index, ordered index, and more.

Objectives

  • Learn how to create a multiple column index.
  • Learn the tradeoffs between different types of indexes.
  • Learn when to order your index columns.

Mission Outline

1. Querying with Multiple Filters
2. Bitmap Heap Scan
3. Adding Another Index
4. Multiple Indexes
5. The Tradeoff of Using Indexes
6. Order By Index
7. Index on Expressions
8. Partial Indexes
9. Building a Multi-Column Index
10. Next Steps
11. Takeaways

optimizing-postgres-databases-data-engineering

Course Info:

Optimizing Postgres Databases

Intermediate

The median completion time for this course is 4.7 hours.

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