SQL Indexes — #17

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