Database Indexes - You Might Be Using Them Wrong
Database indexes can speed up queries but can also silently tank your write performance.
We all know indexes make queries faster. But few understand the B-tree structure underneath, why column order in composite indexes matters, or when adding an index makes things worse. This video covers the fundamentals every developer should know.
What you'll learn:
How B-trees organize data and why they're so efficient
Why composite index column order changes everything
What covering indexes do and when to use INCLUDE
When indexes hurt performance (write overhead, buffer pool pressure, low cardinality)
Timestamps:
0:00 Intro
0:50 What Problem Do Indexes Solve?
2:08 The B-Tree — How Indexes Actually Work
5:40 Composite Indexes and Why Order Is Everything
10:19 Covering Indexes
12:51 When Indexes Hurt
16:47 Practical Advice
More Videos :
Software Egineering Basics - • Software Engineering Basics
Software Design - • Software Design
#database #postgresql #mysql #sqlserver #btree #programming