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

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/