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

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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit