diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2019-08-29 15:37:49 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2019-08-30 12:02:40 +0300 |
| commit | ef76f81c982bdbcfa4797ce26224db9c016ddebd (patch) | |
| tree | 2f65a45620e011e24ddd4fd80d2eae35a28c4f7a /include/source_revision.h.in | |
| parent | d58437d1956b2fd92197beac2e9c869ef968eba7 (diff) | |
| download | mariadb-git-ef76f81c982bdbcfa4797ce26224db9c016ddebd.tar.gz | |
MDEV-20109: Optimizer ignores distinct key created for materialized...
(Backported to 10.3, addressed review input)
Sj_materialization_picker::check_qep(): fix error in cost/fanout
calculations:
- for each join prefix, add #prefix_rows / TIME_FOR_COMPARE to the cost,
like best_extension_by_limited_search does
- Remove the fanout produced by the subquery tables.
- Also take into account join condition selectivity
optimize_wo_join_buffering() (used by LooseScan and FirstMatch)
- also add #prefix_rows / TIME_FOR_COMPARE to the cost of each prefix.
- Also take into account join condition selectivity
Diffstat (limited to 'include/source_revision.h.in')
0 files changed, 0 insertions, 0 deletions