dynamobi/dynamobi — Issue #126: [LDB-196] Optimize to aggregate values from compressed column store segments
Author: dynamobi-build
Created: 2011-12-30 02:15:14+00:00
State: open
Labels: LDB, Optimizer

[reporter="ngoodman", created="Fri, 4 Sep 2009 15:59:13 -0500 (GMT-05:00)"]
LucidDb can currently rewrite count(col) to an idx only scan on a bitmap idx for a column. It won't use the clustered idx. Create an optimization/relnode that will rewrite agg(col) to use a similar technique on the compressed column store segments.

In general, we're hoping to replace many (if not all) occurences of

LcsRowScanRel -> LhxAggRel

with

LcsRowScanAggRel

A step that acutal performs the aggregations on the compressed column store indexes instead of materializing and then iterating over rows.