calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <jul...@hydromatic.net>
Subject Re: Tiles & Lattice HOWTO
Date Tue, 05 May 2015 02:37:25 GMT
> Ah... this is the real motivating point it seems.

Well, not really. A lattice based on a single table is still really useful.

On Mon, May 4, 2015 at 7:20 PM, Ted Dunning <ted.dunning@gmail.com> wrote:
> On Mon, May 4, 2015 at 11:13 PM, Julian Hyde <julianhyde@gmail.com> 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.

Mime
View raw message