How do indexes make databases read faster?

Applied AI Course: https://arpitbhayani.me/applied-ai System Design for SDE-2 and above: https://arpitbhayani.me/masterclass System Design for Beginners: https://arpitbhayani.me/sys-design Build Your Own Redis / DNS / BitTorrent / SQLite - with CodeCrafters. Sign up and get 40% off - https://app.codecrafters.io/join?via=... Recommended videos and playlists If you liked this video, you will find the following videos and playlists helpful Redis Internals:    • Why and How Is Single-Threaded Redis Fast ...   Redis Internals Reading Material: https://docs.google.com/document/d/1l... System Design:    • PostgreSQL connection management and per-c...   Designing Microservices:    • Should You Adopt Microservices? Here’s Wha...   Database Engineering:    • How nested loop, hash, and merge joins work.   Concurrency In-depth:    • How to write efficient and fair multi-thre...   Research paper dissections:    • The Google File System - Paper Explained   Outage Dissections:    • Dissecting GitHub Outage and things to do ...   Hash Table Internals:    • Internal Structure of a Hash Table   Bittorrent Internals:    • Introduction to BitTorrent and the problem...   Things you will find amusing Bookshelf: https://arpitbhayani.me/bookshelf Papershelf: https://arpitbhayani.me/papershelf Other socials I keep writing and sharing my practical experience and learnings every day, so if you resonate, then follow along. I keep it no fluff. LinkedIn:   / arpitbhayani   Twitter:   / arpit_bhayani   Thank you for watching and supporting! It means a ton. I am on a mission to bring out the best engineering stories from around the world and make you all fall in love with engineering. If you resonate with this, then follow along. I always keep it no-fluff.