Artwork

Content provided by Brian Olsen and Trino Community. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brian Olsen and Trino Community 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!

7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?

1:11:55
 
Share
 

Manage episode 280616814 series 2796878
Content provided by Brian Olsen and Trino Community. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brian Olsen and Trino Community 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.

Table of Contents:

- Intro Song: 00:00

- Intro: 00:20

- News: 3:27

- Concept of the week: Cost Based Optimizer 16:48

- PR of the week: PR 1415 Decorrelate subqueries with Limit or TopN 43:09

- PR Demo: EXPLAIN Decorrelate subqueries with Limit or TopN 53:36

- Question of the week: Will running Presto on my relational database make processing faster? 1:02:24

Show Notes: https://trino.io/episodes/7.html

Show Page: https://trino.io/broadcast/

  continue reading

55 episodes

Artwork
iconShare
 
Manage episode 280616814 series 2796878
Content provided by Brian Olsen and Trino Community. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brian Olsen and Trino Community 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.

Table of Contents:

- Intro Song: 00:00

- Intro: 00:20

- News: 3:27

- Concept of the week: Cost Based Optimizer 16:48

- PR of the week: PR 1415 Decorrelate subqueries with Limit or TopN 43:09

- PR Demo: EXPLAIN Decorrelate subqueries with Limit or TopN 53:36

- Question of the week: Will running Presto on my relational database make processing faster? 1:02:24

Show Notes: https://trino.io/episodes/7.html

Show Page: https://trino.io/broadcast/

  continue reading

55 episodes

All 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