This is a great example atte of a tip i didn't mention, but it's probably index related. So were throwing away rows at the end here, and going down from forty five thousand in the second to last operation down to a hundred in the last one. If we could filt down to that much smaller number very earlier on, we could avoid there's a couple of large sequential scans there,. A couple of hash joins, all on tens of thousands of rows of data. And in this case, there's no big filter until the end. In fact, we'll actually see, on these sequential scans, we're saying, index it zero b beas no ros are

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode