sundry

OceanBase cost based query rewriting (or-expansion)

Oceanbase currently implements a cost based query rewriting (or-expansion). In fact, many advanced rewriting rules in the database (such as complex view merge and window function rewrite) need to be rewritten based on cost.

Or-expansion rewrites a query into several subqueries composed of union. This rewrite may provide better optimization space for each sub query, but it can also lead to execution of multiple sub queries, so this rewriting needs to be judged at cost.

Fabulous ( One thousand three hundred and two )

This article is composed of Ji Chang Xin Creation, article address: Https://blog.isoyu.com/archives/oceanbasejiyudaijiadechaxungaixieor-expansion.html
Use Knowledge sharing signature 4 The international license agreement is licensed. In addition to the reprint / provenance, all originals or translations of this site must be signed before retransmission. The final editing time is September, 16, 2018 at 04:36 afternoon.

Key word:

Hot articles

Commentary:

The commentary has been closed.

  1.  West Feng Li blog
    West Feng Li blog Published in:

    How to judge the value? Monte Carlo search tree?

    •  Ji Chang Xin
      Ji Chang Xin Published in:

      Ah ah, algorithm theory big guy, have you read it?

The comments are closed!