3 docs tagged with "partial indexes"

Partial Indexes in PostgreSQL

Learn how to use partial indexes in PostgreSQL to improve performance and reduce storage costs, and how to manage them in database schema migration easily with Atlas.

Partial Indexes in SQLite

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.

Using PostgreSQL Partial Indexes in Prisma with Atlas

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