calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <>
Subject Re: Tiles & Lattice HOWTO
Date Tue, 05 May 2015 02:20:50 GMT
On Mon, May 4, 2015 at 11:13 PM, Julian Hyde <> wrote:

> Calcite also lets you define materialized views outside of a lattice,
> and it does its best to match queries to such materialized views, but
> does less well. In particular, It doesn't match join queries well. The
> search space for unifying a materialized view containing an N-way join
> to a query containing an N-way join is exponential in N, so it doesn't
> try.

Is it possible to use sub-query structure to hint this?

> If you define a materialized view within a lattice, the structure
> provided by the lattice allows join queries to be matched very
> quickly.

Ah... this is the real motivating point it seems.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message