How to Optimize SQL Queries for High-Performance Enterprise DBs
Designed for Senior backend engineers and database architects responsible for mission-critical enterprise applications handling high transaction volumes. to spark real collaboration and high-energy learning.
A 90-minute virtual workshop for experienced database professionals from fintech and SaaS companies. Participants often struggle with slow-running queries in production, limited by both time and system resource constraints. They seek hands-on, actionable tactics that go beyond textbook tips, as their current optimizations often yield only marginal improvements.
Mystery Query Challenge
Start the session by sharing a real, anonymized SQL query from a billion-row table—one notorious for bogging down dashboards. Participants guess (in chat or poll): What actually makes this query slow? Reveal surprising profiling stats after, sparking debate and attention.
Tap to view the full activity.
Why this works
Curiosity primes learning by engaging the brain’s natural desire for answers, especially when the problem feels real and relevant.
‘Index Intuition’ Busted!
Present three conventional wisdom statements about SQL indexes (e.g., ‘More indexes always speed up queries’). After each, run a quick show-of-hands or emoji poll: fact or myth? Debrief with live query plan screenshots proving or debunking each statement.
Tap to view the full activity.
Why this works
Revealing misconceptions helps learners replace faulty mental models with accurate ones, leading to lasting behavior change.
The 60-Second Query Rewrite
Give participants a poorly written query (copy-paste) and challenge them: In a minute, can you spot one improvement? No pressure—just annotate or comment out a change. Volunteers can share their tweak and explain their logic, with facilitator light feedback.
Tap to view the full activity.
Why this works
Low-stakes, timeboxed tasks reduce anxiety and boost engagement, especially for technical skills.
‘Query Olympics’ Speed Test
Split the group into small teams. Each team receives a sample dataset and a notoriously slow SQL query. Their goal: apply as many tuning tricks as possible in 6 minutes to slash the query run time. Teams post before/after metrics to a leaderboard, and facilitators spotlight the most dramatic gains.
Tap to view the full activity.
Why this works
Competition and time pressure inject energy, reinforce collaboration, and cement learning through immediate feedback.
The CTO’s On-Call Nightmare
Present a vivid real-world dilemma: ‘It’s 2am. The CEO’s dashboard is timing out. You have 10 minutes to diagnose and fix the query—what do you check first?’ Invite a round of rapid-fire suggestions in chat or aloud. Debrief by revealing the actual triage sequence from an enterprise war story.
Tap to view the full activity.
Why this works
Connecting learning to authentic, high-stakes scenarios boosts motivation and mimics real decision environments.
Your Query, Your Legacy
Prompt participants to recall a time their own query slowed down a critical system—or when they inherited a ‘mystery slow’ from someone else. In pairs, share the story and one lesson learned. Volunteers can offer takeaways to the full group, emphasizing how personal habits impact enterprise resilience.
Tap to view the full activity.
Why this works
Personal storytelling and peer teaching foster deep reflection and make abstract risks feel tangible.
Sign up to unlock 3 more activities
Get the full pack, facilitation flow, and more ready-to-run ideas.