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


Manage episode 280616814 series 2796878
By Brian Olsen and Trino Community. Discovered by Player FM and our community — copyright is owned by the publisher, not Player FM, and audio is streamed directly from their servers. Hit the Subscribe button to track updates in Player FM, or paste the feed URL into other podcast apps.

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/

20 episodes