Relational Database Indexing | Simple, Compound, B-Trees
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/...
🥹 If you found this helpful, follow me online here:
✍️ Blog / irtizahafiz
👨💻 Website https://irtizahafiz.com
📲 Instagram / 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