medium10 pts · first answer countsindexingpostgresql

Covering index

Which PostgreSQL index allows SELECT email FROM users WHERE status = 'active' to run as an index-only scan?

A.CREATE INDEX ON users (email)B.CREATE INDEX ON users USING hash (status)C.CREATE INDEX ON users (lower(status))D.CREATE INDEX ON users (status) INCLUDE (email)

← Why use a connection pooler Slow deep pagination →