Coding Blocks cover image

Designing Data-Intensive Applications – To B-Tree or not to B-Tree

Coding Blocks

00:00

Query Execution Plan - Is That Really a Good Idea?

The efficiency for that kind of look up is largely depending on how many hops you have. You if you have to go through a hundred hops, then that's like loading pages a hundred times and looking for stuff. And so if you ever look like a poorly peforming query, i think, even when you re in the analyzer, you can actually see a little bit o information about like the paging or sequel server. If you haven't ever done that, it's always a good interview question if you're going somewhere where youre dealing with a lot of sequal servir stuff.

Play episode from 23:02
Transcript

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app