Digis (Ukraine) Interview Question

How would you optimize PostgreSQL queries for better performance?