MySQL-5.7-8.2.1.4 Engine Condition Pushdown Optimization

This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for evaluation. This optimization can be used only by the NDB storage engine.

这种优化提高了在非索引列和常量之间直接比较的效率。在这种情况下，将条件“下推”到存储引擎进行评估。此优化仅支持NDB存储引擎使用。