Slide 1

Slide 1 text

R* Optimizer Validation and Performance Optimization for Distributed Queries Lothar F. Mackert, Guy M. Lohman IBM Almdaden Research Centre

Slide 2

Slide 2 text

Introduction

Slide 3

Slide 3 text

R*

Slide 4

Slide 4 text

Query Optimisation

Slide 5

Slide 5 text

Distributed Query Optimisation

Slide 6

Slide 6 text

Cost Function

Slide 7

Slide 7 text

Tasks

Slide 8

Slide 8 text

Questions to Answer

Slide 9

Slide 9 text

Distributed Joins

Slide 10

Slide 10 text

Inner Table Transfer Strategy

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

No content

Slide 13

Slide 13 text

Distributed VS Local

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

Relative Cost Importance

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

Optimiser Evaluation

Slide 19

Slide 19 text

Alternative Distributed Join Methods

Slide 20

Slide 20 text

High Speed Medium Speed

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

Other Parameters