PostgreSQL Indexing

Ensure fast search queries.

Create Index:

CREATE INDEX idx_users_email ON users (email);

Explain Query:

EXPLAIN ANALYZE SELECT * FROM users WHERE email = 'test@test.com';