CloudBeesSeptember 2026
Interview question
Describe your PostgreSQL and SQL experience, including indexes you have created or database issues you have solved.
Follow-up questions
- How would you reduce unnecessary database scans?
- An API generates a query whose execution switches between a fast plan and a slow plan. Have you ever pinned a preferred query plan, and how would you approach that situation?
- What factors determine whether you add an index to an existing column?