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 SQL Is Scanning Rows It Never Uses

Database Star

September 7, 2026 31

0 Watch on YouTube

???? Get the guide to pagination queries: https://tubular-dolphin-9ead68.netlify.app/go/3?video=MTCjb4-pcqk&source=description
???? Get 56 bad query patterns & fixes: https://tubular-dolphin-9ead68.netlify.app/go/62?video=MTCjb4-pcqk&source=description

In this video, I explain a certain type of query that can get worse with the more data you add, and a concept you can implement to make it run much faster.

TIMESTAMPS:
00:00 - The setup
02:37 - The execution plan
05:16 - What can we do?
07:13 - The updated execution plan

0 Comments

No comments yet. Be the first to weigh in.