首先在逻辑上将表与其自身连接,然后将更具有选择性的非起始索引键作为索引绑定过滤器,应用于起始键值的每个惟一的组合。
The table is logically joined to itself, and the more selective non-leading index keys are applied as index bound filters to each unique combination of the leading key values.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
作为选择,你可以在连接前不考虑默认的连接配置选择选择键。
Alternatively, you can select the Options... button to override the default connection configuration before connecting.
作为选择,你可以在连接前不考虑默认的连接配置选择选择键。
Alternatively, you can select the Options... button to override the default connection configuration before connecting.
应用推荐