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

EAV vs Normalised - An SQL Performance Test

Database Star

September 14, 2026 22

0 Watch on YouTube

???? Get the ultimate guide to the EAV design (plus alternatives): https://tubular-dolphin-9ead68.netlify.app/go/32?video=_EoSCI-Otgs&source=description
???? Get the 7-step framework I use to design any database: https://tubular-dolphin-9ead68.netlify.app/go/61?video=_EoSCI-Otgs&source=description

In this video, I'll explain the EAV database design concept and a normalised design, and compare the performance of both designs using several real queries.

TIMESTAMPS:
00:00 - The schemas
03:33 - Our queries
06:28 - Execution plans

0 Comments

No comments yet. Be the first to weigh in.