3 docs tagged with "partial indexes"

Use partial indexes in PostgreSQL to improve performance and reduce storage costs, and manage them in schema migrations with Atlas.

What partial indexes are in SQLite, when they beat a full index, and how to declare one in an Atlas HCL schema so Atlas plans the migration for you.

Learn how to implement PostgreSQL partial indexes in Prisma using Atlas. This guide covers defining partial indexes, configuring Atlas, and managing migrations.