7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?
Dec 21, 2020•1 hr 12 min•Ep. 7
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more
Episode description
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/
For the best experience, listen in Metacast app for iOS or Android