-- Create a standard B-tree index
CREATE INDEX idx_users_email ON users(email);

-- Create index without blocking writes
CREATE INDEX CONCURRENTLY idx_users_email ON users(email);

-- Remove the index
DROP INDEX idx_users_email;

-- Analyze query performance
EXPLAIN ANALYZE
SELECT * FROM users WHERE email = '[email protected]';