SQL Indexes - #17
Welcome to Learning at Lambert Labs session #17. This week, Tom discusses indexes in the context of a SQL database table, and how they can be used to improve query speed.
In Today's Learning Session:
Explanation of indexes, and how an indexed table compares to a non-indexed table
Clustered vs non-clustered indexes
Discussion of Tree data structures, including Binary Search Trees and B-trees
Overview of how B-trees are used as indexes
Demonstration of using an index to speed up queries
Video timestamps:
0:00 Introduction
0:27 Explanation of indexes
1:45 Comparison of indexed vs non-indexes tables
3:38 Overview of Tree data structures
6:53 Example implementation of a BST
8:29 Overview of B-trees
11:36 Visual demonstration of a B-tree
13:49 Using an index in a real table
19:19 Trigram indexes
21:33 Using a trigram index
22:43 Questions from the team
🔊 Subscribe to our channel for weekly learning sessions! / @lambertlabs
🔗 Lambert Labs Links 🔗 :
🌎 Website: https://lambertlabs.com/
📱 Twitter: / lambertlabs
📝 LinkedIn: / lambertlabs
📂 GitHub: https://github.com/lambertlabs
⚡ Please leave a LIKE and SUBSCRIBE for more content! ⚡
⭐ Tags ⭐
SQL
Database Engineering
Python
Development
Software Engineering