calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy Grove <>
Subject Re: Implementing a table that can be queried by index (noob question)
Date Sat, 09 May 2015 20:48:32 GMT
Hi Vladimir,

Thanks for the information.

So is there a way I can force my query to run with a nestedloop(fullscan,
indexscan) or would this involve changes to Calcite?

I didn't know about the call, but yes, I'd like to join if it is an open



Andy Grove
Chief Architect
CodeFutures Corporation

On Sat, May 9, 2015 at 2:07 PM, Vladimir Sitnikov <> wrote:

> Hi,
> Here are my rants on the subject:
> 1)
> 2) Currently Calcite tries to fully de-correlate the queries. In other
> words, Calcite "never" produces a "nested loops" execution plan.
> Well, it does support Correlate plans (it can even execute ones), but
> typically you want cost-based de-correlation. For instance, it would
> be nice if Calcite could compare "hashjoin(fullscan, fullscan)" vs
> "nestedloops(fullscan, indexscan)" on a cost basis.
> I have not yet moved in the direction, however I hope I reach that goal.
> Are you going to join hangout on the 13th May 10am pacific?
> It could be a good discussion topic.
> Vladimir

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