An index push-down has the following advantages.
索引下推包含以下优点。
The pushed-down join keys can be used in an index pushdown or a bit-vector push-down.
下推连接键可用于索引下推或位向量下推。
The push-down decision is made by the wrapper during the planning phase, while working with the query optimizer.
下推的决定是包装器在计划阶段与查询优化器一起做出的。
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.
下推散列连接的主要目的是减少处理的事实表行数，这样可以探测每个散列表。
Listings 7 and 8 show a sample CIM-XML message exchange — request and response — with the CIMOM (over HTTP) in the push-down method through the CIM Adapter.
清单7和8展示了一个CIM - XML消息交换的范例——通过CIM适配器使用叠加方法中的CIMOM(基于HTTP)来进行请求和响应。
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.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是，在初期减少了事实表(探测表)的行数。
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.
在位向量下推中，对于每次下推，数据库服务器通过散列维度表中的键来创建发送至事实表的位向量。
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，因为这是关系数据源下推分析和查询优化器确定计划的基础。
Very much the same in the south except that the rain is starting to push down into the northern parts of the Mediterranean there.
南部地区的情况非常相似，除了降雨开始向地中海北部地区推进。
They can push down the thirteenth partial and bring up the fifteenth and thereby change the sound of a clarinet into a French horn.
他们可以压低第十三分音，或者提高第十五分音，从而将单簧管的声音变成圆号的。
Understanding the capabilities of the data source enables the federation server to push down more functionality to that data source, which generally improves performance.
理解数据源的能力之后，联邦服务器就可以将更多的功能下推到那个数据源，这通常可以提高性能。
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.
如果您希望联邦服务器将函数的计算下推到一个关系数据源，那么必须使用那个数据源的一个函数映射。
Crews are slowly pumping heavy drilling mud into a cap on the top of the well, to push down hydrocarbons that are already present in the well pipe.
工程人员正在缓慢地将特殊泥浆注入井口上的控油罩，将油井管道中已经形成的碳氢化合物压在下面。
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.
但是在某些情况下，在创建昵称之后，可能需要添加索引信息和统计信息，以便让优化器下推与昵称一起使用的谓词。
The BIS reckons debt burdens and falling home values will again combine to push down GDP growth.
BIS估计债务负担和下跌的房产价值将再一次组合来推低gdp的增长。
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.
如果您想将定义远程视图的查询下推到数据源，那么定义远程视图的昵称会比较有用。
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，就可以获得最大的益处。
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)与昵称一起使用的谓词。
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操作下推到远程数据源，大多数谓词的计算、聚合、排序和连接仍然是在本地完成。
For example, instead of eating to push down unhappy feelings, you can discover new ways to soothe yourself while you feel unhappy. Ask yourself.
比如，不再用胡吃海塞压下不幸福的感觉；在感觉不幸福时，你会找到让自己舒服的新方法。
LOS ANGELES (MarketWatch) -- Japan's Ministry of Finance may consider intervening in the currency markets to push down the yen without the help of other nations, according to a report Wednesday.
洛杉矶（MarketWatch）--据周三的一份报道显示，日本财务内阁正考虑在没有他国帮助下独自介入市场去推动日元走低。
That could push down farmland values by half, a recipe for ruin for those who have borrowed against the value of their property.
这可能导致农地价格下跌一半，对于那些先前以其物业原价抵押贷款的人们来说，这无疑将是毁灭性的打击。
And it heard evidence that migrants may push down the "natural" rate of unemployment, since they are more flexible than sluggish Britons about which jobs they take.
同时，文章又说，移民会降低“自然”失业率，因为那些移民相对于迟钝的英国人来说，在工作的选择方面要灵活的多。
Use your hand or a clean cloth, paper towels, a scarf, or any fabric you can grab, and push down on the wound until the bleeding stops.
用你的手或干净的布、纸巾、围巾或在你旁边能抓住的任何布料，按住伤口，直到流血止住。
But on Monday last week, as investors feared official borrowing costs were becoming unsustainable, the ECB intervened to push down Italian and Spanish yields from above 6 per cent to 5 per cent.
上周一，由于投资者担心这两国的官方借贷成本将变得难以维系，欧洲央行入市干预，使意大利和西班牙国债的收益率从6%以上降至5%。
Even though no specific plans have been announced, the issue is weighing on markets since higher taxes would push down the value of properties.
尽管未宣布具体计划，但由于税赋的增加将会压低房产的价值，这一问题还是对市场造成了巨大的压力。
Big supply gluts in Ireland and Spain are likely to push down house prices there for some time to come.
未来一段时间内，爱尔兰和西班牙的房屋供给过剩很可能使当地房价下跌。
Big supply gluts in Ireland and Spain are likely to push down house prices there for some time to come.
未来一段时间内，爱尔兰和西班牙的房屋供给过剩很可能使当地房价下跌。
应用推荐