SERGE AURUBIN

DATA SCIENTIST

Welcome to my blog for everything having to do with data science and analysis. I am always looking for new opportunities to drive business insight using data analysis.

Data & Analytics

Data Analysis
Power BI
Excel
Data Pipelines
Matillion

Engineering

Software Developer
Python
PHP
ReactJS
Flutter
Front End Dev
Back End Dev

Databases

MySQL Dev/DBA
Oracle DBA

Cloud & AI

Amazon Web Services
Docker
Kubernetes
Git
Artificial Intelligence
Claude
OpenAI

Back to Videos

This Query Ran 5,100 Times a Day. Nobody Had Noticed.

Database Star

August 16, 2026 41

0 Watch on YouTube

???? Get the SQL Performance Checklist: https://deploy-preview-14--tubular-dolphin-9ead68.netlify.app/go/5?video=-hLsj3JkX0I&source=description
???? Get 56 bad query patterns & fixes: https://deploy-preview-14--tubular-dolphin-9ead68.netlify.app/go/62?video=-hLsj3JkX0I&source=description

In this video, I'll explain a problematic query I found at work, why it was a problem, and how I fixed it.

TIMESTAMPS:
00:00 - The query
01:56 - The execution plan
04:02 - Investigating the data
08:12 - A bonus improvement

0 Comments

No comments yet. Be the first to weigh in.