Database management systems notes

Using Indexes Well

Selectivity, covering indexes, partial indexes, and deciding what should exist. Every section is a drawn page beside a clear written explanation, about 20 minutes in all.

  • Chapter 21 of 34
  • About 20 minutes
  • 6 sections
Sign in to open it See plans

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of Using Indexes Well: Selectivity decides everything
The chapter's first page: Selectivity decides everything

In this chapter

  • Selectivity decides everything
  • Covering indexes and index-only scans
  • Partial indexes
  • Indexing an expression
  • Deciding what should exist
  • Keeping indexes healthy

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

Sign in to open itSee plans

DSA comes with the all labs plan and every ChaiCode batch.