# SAP HANA pushdown limit

not possible if DISTINCT is used even if the hint PRELIMIT_BEFORE_JOIN is applied.

The limit pushdown for parameter value is triggered only if the above hint is given.HANA optimizer is not rule-based but cost-based optimizer.
On other DBs we always had the possibility to specify something like an optimization target “optimize for first rows”, which means that the optimizer should choose a plan, which is optimal for a small number of records.
PRELIMIT_BEFORE_JOIN rule can be applied to constant LIMIT operator. But cannot be applied to parameterized LIMIT cases for technical reason, unless we are well aware of how much records could be pruned with LIMIT operator, we cannot estimate its cost and decide the optimal plan based on the estimated cost.

07-10 1万+

10-26 2880

11-23 1159

08-17 1748

05-21 422

11-26 277

07-29

03-30 3303

04-15 1万+

06-26

06-10 3万+

06-19 1万+

#### MFC一站式终极全套课程包

09-28
©️2020 CSDN 皮肤主题: 深蓝海洋 设计师: CSDN官方博客

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、C币套餐、付费专栏及课程。