如果连接列上不存在索引,那么优化器将选择动态哈希连接。
The optimizer will choose dynamic hash join if none of the joined columns has index.
哈希连接通常比分类合并连接快,因为它没有涉及到分类操作。
A hash join is usually faster than a sort merge join since there is no sort operation involved.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
在IDS版本7以及更高版本中,该连接方法已被动态哈希连接所取代。
This join method is replaced by dynamic hash join for IDS version 7 and above.
正如上面所提到的,动态哈希连接是IDS版本7以及更高版本中的新连接方法。
As mentioned above, dynamic hash join is a new join method for IDS version 7 and above.
动态哈希连接包含两个动作:构建哈希(或者是我们所称的构建阶段),以及探测哈希表(或探测阶段)。
The dynamic hash join consists of two activities: building the hash (or build phase as we call it), and probing the hash table (or probe phase).
连接计划指示,强制优化器使用指定的连接方法来连接查询中的表,要么是嵌套循环连接、分类合并连接,要么是动态哈希连接。
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
在前一个实例中,如果customer . customer_num和orders . customer_num都没有被索引,那么优化器将选择动态哈希连接来作为最佳的执行计划。
In the previous example, if customer.customer_num and orders.customer_num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan.
您将找到的大部分结果都是哈希索引站点——有意地连接散列值和其相应关键字的站点。
Most of the results you'll find are hash indexing sites — sites intentionally built to connect hash values and their corresponding keys.
由于您需要连接字符串的解密版本才能连接到数据库,因此无法对连接字符串进行哈希处理。
Since you will need the decrypted version of a connection string to connect to the database, you can't hash a connection string. You will need to encrypt it, instead.
NET 2.0包括应该简化密码哈希和连接字符串加密的许多功能。
ASP.NET 2.0 includes a number of features which should simplify the hashing of passwords and the encryption of connection strings.
如果证书有致命的问题(例如,哈希值无效),那么将无法建立连接。
If there are fatal problems with the certificate — for instance, if the hash values are not valid — then the connection simply won't happen.
getCreateConnection()方法使用静态哈希表来确定是否可以返回现有连接,或需要进行创建。
The getCreateConnection() method uses a static hash table to determine if either an existing connection can be returned, or needs to be created.
在扫描完第一个表并将它放在哈希表中之后,就扫描第二个表,并在哈希表中查找该表中的每一行,看是否可以进行连接。
After the first table has been scanned and placed in a hash table, the second table is scanned and each row in the table is looked up in the hash table to see if a join can be made.
拥有相同哈希函数和分区策略的相互连接的哈希运算符组的根成员。
The root member of a team of connected hash operators sharing a common hash function and partitioning strategy.
拥有相同哈希函数和分区策略的相互连接的哈希运算符组的根成员。
The root member of a team of connected hash operators sharing a common hash function and partitioning strategy.
应用推荐