A star join plan utilizing push-down hash join technology makes hash joins more effective primarily due to reduction of fact table (probe table) rows early on.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是，在初期减少了事实表(探测表)的行数。
Star join plan utilizes push-down hash join technology.
星型连接计划利用下推散列连接技术。
Push updates allow updates to be pushed down by an administrator without any interaction on the user's part.
推式更新允许管理员下推更新，无需与用户方进行任何交互。
The primary purpose of a push-down hash join is to reduce number of rows processed from the fact table, which probes each of the hash tables.
下推散列连接的主要目的是减少处理的事实表行数，这样可以探测每个散列表。
To push the join between the two catalogs down to the database vendor, simply have both Content Manager data source properties point to the same IBM Cognos BI data source name.
要将两个目录之间的联接向下推到数据库供应商，只需将这两个ContentManagerDataSource属性指向同一个IBMCognosbi数据源名称。
Inspect the optimized SQL in the db2exfmt or Visual Explain output, as this is the basis for the planning decision of the relational data source push-down analysis and the query optimizer.
检查db 2 exfmt或VisualExplain输出中经过优化的SQL，因为这是关系数据源下推分析和查询优化器确定计划的基础。
Step 2.4: Look for other push-down opportunities.
步骤2.4：寻找其他下推机会。
If you want the federated server to push down the evaluation of a function to a relational data source, you must use a function mapping for that data source.
如果您希望联邦服务器将函数的计算下推到一个关系数据源，那么必须使用那个数据源的一个函数映射。
Understanding the capabilities of the data source enables the federation server to push down more functionality to that data source, which generally improves performance.
理解数据源的能力之后，联邦服务器就可以将更多的功能下推到那个数据源，这通常可以提高性能。
But in some cases, it may be necessary to add index information and statistics to the nickname after it is created in order to get the optimizer to push down predicates used with the nickname.
但是在某些情况下，在创建昵称之后，可能需要添加索引信息和统计信息，以便让优化器下推与昵称一起使用的谓词。
Defining a nickname over a remote view is useful in cases where you want to push down the query defining the remote view to the data source.
如果您想将定义远程视图的查询下推到数据源，那么定义远程视图的昵称会比较有用。
That would push down sales and prices more.
令锁情及价格进一步向下推。
The push-down decision is made by the wrapper during the planning phase, while working with the query optimizer.
下推的决定是包装器在计划阶段与查询优化器一起做出的。
In a bit-vector pushdown, for each push-down, the database server hashes the keys from the dimension table to create a bit vector, which is shipped to the fact table.
在位向量下推中，对于每次下推，数据库服务器通过散列维度表中的键来创建发送至事实表的位向量。
Being able to push down aggregation operations or very selective predicates to CF (i.e. those that filter out many rows) will result in the greatest benefit.
如果能将聚合操作或选择性非常强的谓词(即能过滤掉很多行的谓词)下推到CF，就可以获得最大的益处。
The pushed-down join keys can be used in an index pushdown or a bit-vector push-down.
下推连接键可用于索引下推或位向量下推。
If the nickname is used by itself, the WebSphere Information Integrator optimizer may still push down predicates used with the nickname.
如果昵称进行自我引用，那么DB 2II优化器仍将下推(push down)与昵称一起使用的谓词。
How do you feel, when I push down here?
我向下推这儿时您有什么感觉？
An index push-down has the following advantages.
索引下推包含以下优点。
Thus, Federation Server can push down only a few SQL operations through the standard ODBC wrapper to the remote source and executes most predicate evaluations, aggregations, sorts and joins locally.
因此，在使用标准的ODBC包装器的情况下，FederationServer只能将少数SQL操作下推到远程数据源，大多数谓词的计算、聚合、排序和连接仍然是在本地完成。
Inhale as you push down with your arms and raise your head, shoulders and upper body as far as you can without straining.
吸气，抬头，同时双臂支撑向下推，尽量让双肩和身体上半部分向上伸展。
When our well-intentioned Chinese observers came to Benjamin's rescue, they did not simply push his hand down clumsily or uncertainly, as I might have done.
那些善意的中国旁观者前来帮助本杰明时，他们不是简单地像我可能会做的那样笨拙地或是犹犹豫豫地把他的手往下推。
During the catch phase they tend to push down on the water rather than pushing it back behind them.
整个抓水过程，他们倾向于在上面向下推水，远多于向后推水到身后。
But it will be different if someone pushes down on your shoulders. In this situation you do not push back up - you just absorb the push effortlessly into your posture.
但当有人从上而下推按你的肩膀时情况就不同了，这时你不需要顶抗，就会毫不费力吸收掉作用在身体上的力。
Often the chair seat is caused by the rider trying to push his heels down.
“坐椅子”常常是由于骑手想把脚跟向下推造成的。
Use all your fingers curved to push down from the pit of the stomach to the belly. Repeat this pushing as many times as you want.
拿十个手指肚交叉往心窝下推，先在心窝停留一下，再往下推。
They feature a silver handle on the oven door, three black knobs for controlling cooking, and a black push-down lever for toasting.
其特征为在烤箱的门上有一个银色的把手、三个控制烹饪的黑色旋钮，以及一个黑色的供烤面包片使用的下推控制杆。
They feature a silver handle on the oven door, three black knobs for controlling cooking, and a black push-down lever for toasting.
其特征为在烤箱的门上有一个银色的把手、三个控制烹饪的黑色旋钮，以及一个黑色的供烤面包片使用的下推控制杆。
应用推荐