Query Planning and Optimization

Dormant Last read 3 days ago · last published 6 years ago · next check scheduled
Read 3 days ago and current, but nothing has been published for 6 years.

Written by

This blog elsewhere

Latest videos

Saves to your Watch queue, to pick up on another day or another device.

External Sorting

Dec 16, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Query Planning and Optimization

Oct 14, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.533 Operator Example Implementations

Jun 5, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.550 Anti-Projection, Tuple Reconstruction, Early and Late Materialization

May 9, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.530 Implementing Pipelines, Operators, Iterators, ResultSet-style Iteration...

Apr 30, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.528 Query Execution Models, Function Calls vs Pipelining, Pipeline Breakers

Apr 14, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.516c Dynamic Programming Optimizations: Interesting Orders, Graph Structure

Apr 7, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.516b Dynamic Programming Example without Interesting Orders, Pseudo-Code

Apr 7, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.516a Dynamic Programming: Core Idea, Requirements, Join Graph

Apr 7, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.514 Cost-Based Optimization, Plan Enumeration, Search Space, Catalan Numbers, Identical Plans

Apr 1, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.503 Challenges in Query Optimization: Join Order, Costs, and Index Access

Mar 27, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.502 Challenges in Query Optimization: Rule-Based Optimization

Mar 26, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

14.500 Query Optimizer Overview

Mar 26, 2014 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play