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 Went From 13 Minutes to 0.9 Seconds

Database Star

June 29, 2026 28

0 Watch on YouTube

???? Get my Correlated Subquery guide: https://deploy-preview-14--tubular-dolphin-9ead68.netlify.app/go/36?video=PlgbzYDfXug&source=description
???? Get 56 bad query patterns & fixes: https://deploy-preview-14--tubular-dolphin-9ead68.netlify.app/go/62?video=PlgbzYDfXug&source=description

In this video, I start with a query that takes 13 minutes to run, investigate it, and get it running in under 1 second.

TIMESTAMPS:
00:00 - Our query
01:00 - Understand the query
03:11 - The execution plan
05:29 - Making a change
08:40 - Check the new plan

0 Comments

No comments yet. Be the first to weigh in.