Welcome to Learning at Lambert Labs session #17. This week, Tom discusses indexes in the context of a SQL database, 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
🔊 Subscribe to our channel for weekly learning sessions! https://www.youtube.com/channel/UCi7G5sY0IWqSNUMnRptuJmw 🔗
Lambert Labs Links 🔗 :
🌎 Website: https://www.lambertlabs.com
📱 Twitter: https://twitter.com/lambertlabs
📝 LinkedIn: https://www.linkedin.com/company/lambertlabs
📂 GitHub: https://github.com/lambertlabs