Cache Operator Push Down

Cache Operator may be pushed down non-reductive operations

Cache(h,c)

Sort

Join

Hotels

Cities

Initial Plan

Sort

Sort

Cache(h,c)

Join

Hotels

Cities

1. Push Down

Cache(h)

Join

Hotels

Cache(c)

Cities

2. Push Down

Push-down reduces the cost of non-reductive operations

without causing irrelevant objects being copied

Vorherige Folie

Nächste Folie

Zurück zur ersten Folie

Graphik-Version anzeigen