[MCOL-4935] A prototype planner/optimizer using term rewriting Created: 2021-11-30  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Sergey Zefirov Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-4557 Columnstore - Technical debts in Opti... Open

 Description   

Currently columnstore does not have explicit query optimization phase - the optimization process is spread across several modules, some of them rewrite the execution plan (using peephole optimization), some of them rule out some of the operations of execution plan (extent elimination is one example). And, while we have "analyze_table" query, currently we do not have necessary means to use its results in a straightforward way in a planning , let alone use them with ease.

The goals for this particular task are twofold:

  1. create a framework for query optimization stage that can be easily integrable with various parts of columnstore's internal information and
  2. demonstrate its effectiveness on different queries of various complexity - effectiveness in the addition of transformations and effectiveness of the resulting execution plan.

Generated at Thu Feb 08 02:54:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.