这个功能创建到远程注册表的连接。
This function creates a connection to a remote registry. To connect to Gunn, this would look like.
她在登记表的连接处点击一下，开始进入她的信息。
She clicks on the link to the registration form and begins entering her information.
维度表的层次与它需要连接到中心事实表的连接数目有关。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
当连接表的连接列上没有可用索引时，通常使用该连接方法。
This join method is usually used when no index is available on the join columns for the joining tables.
举例来说，清单1中的查询描述了Dept和employee表的连接。
For example, the query in Listing 1 describes a join of the Dept and Employee tables.
此刻数据好像消失了，因为事实表的连接似乎比笛卡尔product结果更加稀少。
Data may seem to disappear at this point since the joins through the fact table is likely more sparse in its combinations than the Cartesian Product results.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
如果语句涉及到更大的表格和两个或者更多个表的连接的话，查询访问计划就很可能会因为基数估计值的提高而改变。
Statements involving larger tables and joins of two or more tables are more likely to exhibit a change in query access plan as a result of the improved cardinality estimate.
通过对上述两个表的连接键(pdb_id)进行散列处理来分布两个表也能确保给定pdbml文档中所有原子行均能作为本身的PDBML文档存储在相同的数据库分区中。
Distributing both tables by hashing on their join key (pdb_id) also ensures that all atom rows for a given PDBML document are stored in the same database partition as the PDBML document itself.
tcb表存储每个活动TCP连接的控制值。
The TCB table stores the control values for each active TCP connection.
相反，可使用具有where子句的虚拟表，或者将连接作为数据源的视图进行定义，并在这一视图中执行规则。
Instead, use a virtual table with a WHERE clause, or define the join as a view in the data source, and execute the rule on this view.
正如上文所示，对具体类的查询只选择需要的数据，没有不必要的表连接和联合。
As shown above, queries on concrete classes only select the required data without unnecessary table joins or unions.
关系数据库为sql语句提供了从一个以上的表中访问信息的能力，这是通过连接多个表来完成的。
Relational databases provide the capability for the SQL statements to access information from more than one table through a joining of multiple tables.
编写使用这些比较高级的表连接的SQL查询将在后续文章中介绍。
Writing SQL queries that use these more advanced table joins will be addressed in future articles.
引用完整性是一个美妙的sql术语，它指的是保持数据库中的所有数据都是干净的，没有错误或者多余的数据，表之间的连接准确合理。
Referential integrity is a fancy SQL term that refers to keeping all the data in your database clean, free from incorrect or unused data, and accurate in terms of joins across tables.
由于每个维度表过滤的选择度，每次连接都会减少事实表大小的十分之一。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
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.
该表强调了任务数据和使用查询表的补充数据的连接。
This table also highlights the join of task data with supplemental data using a query table.
伪事实表将会用在连接中代替实际的事实表，从而提升单独从维度查询的响应时间。
The fake fact table will be used in the joins instead of the actual fact table, thereby improving response times when querying solely from the dimensions.
事实表和任何维度表之间的连接都是等值连接，这使得散列连接成为可能。
The join between the fact table and any dimension table is an equi-join, which makes a hash join possible.
其原因是：规范化需要更多的表，连接等操作，主键、索引，从而需要更多的内部操作。
The reason: Normalization requires more tables, table joins, keys and indexes and thus more internal database operations for implement queries.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
这个查询对每个事实表和维度表之间的连接使用散列连接。
This query plan uses hash join for each join between the fact table and a dimension table.
对于具有经常被请求的列的多个表，一种是复制其中的数据，一种是执行表连接，两者谁的成本更高呢？
Is the duplication of data in multiple tables of frequently requested columns, more or less expensive than performing the table joins?
创建并保存表定义后，该设计器允许根据该表所属连接的DB 2平台对其进行一定程度的更改。
After creating and saving the table definition, the designer allows certain alterations to the table depending on the DB2 platform of the connection it belongs to.
该连接的执行过程包括扫描散列连接中的内表CUSTOMERS，并通过散列连接列的值生成一个查找表。
The join is performed by scanning the inner table of the hash join, CUSTOMERS, and generating a lookup table by hashing the join column values.
细粒度的数据表意味着更多数据表连接，相应的查询也会更复杂。
Having fined-grained database tables means more table joins and accordingly more complex queries.
这条经典欧洲线路在大多欧洲联票的日程表上都有，连接两个中欧的精华目的地。
This classic European journey features on most Inter-Railers itinerary, connecting two of central Europe's essential destinations.
它将提示您选择连接并输入新表的名称。
It prompts you to select the connection and to enter the name for the new table.
应用推荐