结果,该引擎必须读取很多数据行然后使用实际行数据应用最终过滤,即使过滤列的索引可用。
As a result, the engine needed to read many rows of data and apply the final filters using the actual row data, even though indexes of the filter columns were available.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
因为我太高,所以我不得不从我吃的叶子中获得水分,而不是从地上,因此,我实际上能前行数月而不必喝水。
And because I'm so tall, I have to get water from the leaves I eat instead of from the ground. So I can go for months without actually drinking.
应用推荐