[jira] [Commented] (ASTERIXDB-3046) Add support for cost-based optimization

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-3046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17605614#comment-17605614 ] 

ASF subversion and git services commented on ASTERIXDB-3046:
------------------------------------------------------------

Commit 243ef2abd06424664ae2a653aedd0f5ec2db54ba in asterixdb's branch refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=243ef2abd0 ]

[ASTERIXDB-3046][COMP] Support cost based query optimization.

- user model changes: yes
- storage format changes: no
- interface changes: yes
  added: ICost, ICostMethods
  modified: IAccessMethod

Details:
Cost based query optimization enables the optimizer to compute
the optimal plan for a query.

- Add new rule EnumerateJoinsRule to run the CBO logic.
- Add new rule AnnotateOperatorCostCardinalityRule to annotate
  operators with cardinalities and costs.
- Add 3 compiler properties to control CBO:
  compiler.cbo, compiler.forcejoinorder, compiler.queryplanshape
- Add 3 hints: hashjoin, selectivity, productivity.
- Add new operator annotations:
  INPUT_CARDINALITY, OUTPUT_CARDINALITY, TOTAL_COST, OP_COST
  LEFT_EXCHANGE_COST, RIGHT_EXCHANGE_COST
- Make tests run in CBO test mode.

Change-Id: I848adf6a8fdcfea360655ab649de2fb75a73c814
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17143
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> Add support for cost-based optimization
> ---------------------------------------
>
>                 Key: ASTERIXDB-3046
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3046
>             Project: Apache AsterixDB
>          Issue Type: Epic
>          Components: COMP - Compiler, HYR - Hyracks, RT - Runtime
>    Affects Versions: 0.9.7
>            Reporter: Ali Alsuliman
>            Priority: Major
>             Fix For: 0.9.9
>
>
> Add support for cost-based optimization using samples.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)