Implementing Database Indexes

1. Creating Single Field Index

@@index([email])

Aspect	Detail
Type	B-tree default
Use	Equality + range queries

Rule	Detail
Leftmost prefix	Index covers queries on leading fields
Order matters	Match query patterns
Example	`@@index([tenantId, createdAt(sort: Desc)])`

Option	Detail
`map`	DB-side index name
Convention	`idx_table_columns`

DB	Approach
PG	Raw SQL: `CREATE INDEX ... WHERE active = true`
MySQL	Not directly supported

DB	Syntax
MySQL	`@@fulltext([title, body])`
PG	Preview `fullTextSearchPostgres`; use `tsvector` in migrations

@@index([token], type: Hash)

Use	Detail
Equality only	No range queries
PG	Hash index supported (durable since PG10)

Tip	Detail
Cover queries	Index all columns in `where` + `orderBy`
Avoid over-indexing	Slows writes
EXPLAIN	Inspect query plans

DB Query	Use
PG	`pg_stat_user_indexes`
MySQL	`sys.schema_unused_indexes`
Tool	pganalyze, PMM, Performance Insights