pingcap/tidb

The heavy predicates may not need to be pushed down.

Open

#14,608 opened on 2020年2月3日

GitHub で見る
 (6 comments) (0 reactions) (1 assignee)Go (6,186 forks)batch import
help wantedsig/plannertype/enhancement

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (平均マージ 14d 4h) (30d で 346 merged PRs)

説明

For example, a big CASE...WHEN... clause may consume a lot of resources. In this case, push it down to table side may be worse than not pushing it.

We should control its behavior by

  • A hint to disable all predicates of one WHERE clause.
  • A cost-based or a heuristic method to control the predicates automatically.

コントリビューターガイド