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