Artwork

Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Back to basics: The structure of an index

22:36
 
Share
 

Manage episode 335905574 series 3376484
Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

Pick up a reference book and there will most likely be an index at the back to help you locate particularly topics. Are database indexes the same? The goal of indexes in the database is allow rapid lookup of a known value in a table. But how do they achieve this? The secret lies on the structure used by indexes to ensure that finding a value even in billions of rows can be virtually instantaneous. In this episode, we'll extend the book metaphor to explain how database indexes work. Enjoy!

Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.


  continue reading

41 episodes

Artwork
iconShare
 
Manage episode 335905574 series 3376484
Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

Pick up a reference book and there will most likely be an index at the back to help you locate particularly topics. Are database indexes the same? The goal of indexes in the database is allow rapid lookup of a known value in a table. But how do they achieve this? The secret lies on the structure used by indexes to ensure that finding a value even in billions of rows can be virtually instantaneous. In this episode, we'll extend the book metaphor to explain how database indexes work. Enjoy!

Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.


  continue reading

41 episodes

모든 에피소드

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide