Relational Database Indexing | Simple, Compound, B-Trees

Code with Irtiza · Beginner ·🔧 Backend Engineering ·3y ago

Skills: Database Integration53%

About this lesson

We take a closer look at database indexes in relational databases -- simple & compound indexes, if & when indexes are used, what data structures hold these indexes, and the drawbacks of having too many indexes. Notes & References: https://doc.clickup.com/45016410/d/h/1axtau-1702/a845ee8db2d5b2d 🥹 If you found this helpful, follow me online here: ✍️ Blog https://irtizahafiz.medium.com 👨‍💻 Website https://irtizahafiz.com 📲 Instagram https://www.instagram.com/irtiza.hafiz/ 0:00 Agenda 01:15 What is an Index? 04:50 How does an index look? 07:30 Default Index 08:43 Adding an Index 09:50 DB Engine does not use index 12:00 Compound Index 14:40 Order of Index Matters 16:30 B-Trees 18:15 Drawbacks of having too many indexes #database #mysql #postgres

Original Description

We take a closer look at database indexes in relational databases -- simple & compound indexes, if & when indexes are used, what data structures hold these indexes, and the drawbacks of having too many indexes. Notes & References: https://doc.clickup.com/45016410/d/h/1axtau-1702/a845ee8db2d5b2d 🥹 If you found this helpful, follow me online here: ✍️ Blog https://irtizahafiz.medium.com 👨‍💻 Website https://irtizahafiz.com 📲 Instagram https://www.instagram.com/irtiza.hafiz/ 0:00 Agenda 01:15 What is an Index? 04:50 How does an index look? 07:30 Default Index 08:43 Adding an Index 09:50 DB Engine does not use index 12:00 Compound Index 14:40 Order of Index Matters 16:30 B-Trees 18:15 Drawbacks of having too many indexes #database #mysql #postgres

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

More on: Database Integration

View skill →

Cloud SQL with Terraform

How to Install Oracle Database 11g on Windows 10 By Manish Sharma

How to Install Oracle Database 11g on Windows 10 By Manish Sharma

How do I resolve Amazon RDS instance full storage issues when storage auto-scaling is turned on?

How do I resolve Amazon RDS instance full storage issues when storage auto-scaling is turned on?

Amazon Web Services

Basic PHP Programming Tutorial 28: MySQL Database Part 2: Reading From Database

Basic PHP Programming Tutorial 28: MySQL Database Part 2: Reading From Database

Configure & use Amazon FSx for Lustre with Amazon EKS Pods | Amazon Web Services

Configure & use Amazon FSx for Lustre with Amazon EKS Pods | Amazon Web Services

Amazon Web Services

Ultimate Way To Save Archive Redo Logs into Fast Recovery Area

Ultimate Way To Save Archive Redo Logs into Fast Recovery Area

Related Reads

Learn how to start backend engineering with CS50 courses and increase chances of landing a part-time job

Reddit r/learnprogramming

Bringing Convention over Configuration to Fastify with @syora/fastify

Learn how to simplify Fastify development with @syora/fastify, a library that brings Convention over Configuration to the popular Node.js framework

Dev.to · Mamadou

Ralph Loops Are Not About Throwing Away Context

Learn about the Ralph loop technique and how it can be applied in Bash scripting to improve performance

Dev.to · Sangam Pandey

What Happens When a Webhook Retries 47 Times in 10 Seconds

Learn how to handle aggressive webhook retries with a verified PHP + Redis fix pattern

Medium · Programming

Chapters (10)

Agenda

1:15 What is an Index?

4:50 How does an index look?

7:30 Default Index

8:43 Adding an Index

9:50 DB Engine does not use index

12:00 Compound Index

14:40 Order of Index Matters

16:30 B-Trees

18:15 Drawbacks of having too many indexes

/dev/push: An Open Vercel Alternative to Ship Your Apps Quickly