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 1

0 Watch on YouTube

???? Get my Correlated Subquery guide: https://databasestar.mykajabi.com/topic-correlated-subquery/?video=PlgbzYDfXug
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/zPYFUthD/checkout?video=PlgbzYDfXug

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.