Because this method has to sort all joining tables before they join, the costs are usually pretty high.
因为该方法在进行表连接之前，必须将所有的连接表分类，所以其成本通常极其高。
This join method is usually used when no index is available on the join columns for the joining tables.
当连接表的连接列上没有可用索引时，通常使用该连接方法。
The final article in this three-part series covers other ways of cross-referencing data, including joining tables.
三篇文章组成的系列中的最后一篇文章，将会讨论交替引用数据的其他方式，包括交接表格 。
It's almost like joining tables in an SQL query, by selecting tables whose data should be part of the results of the query.
这跟在SQL查询中加入表格很相似，方法就是选择其数据应为查询结果一部分的表格。
Make sure appropriate indexes are used to minimize the rows that have to be fetched internally when selecting and joining tables.
请确保使用合适的索引，从而在选择和连接(join)表时，将必须在内部访存的行数减到最少。
This sample program can give you additional SQL capabilities (like data obtained by joining tables) that are not supported with the UNLOAD utility.
此示例程序可以为您提供UNLOAD实用程序不支持的其他SQL功能(比如通过联接表获得的数据)。
It is used when there are no indexes on one or more joining tables, or when the database server must read a large number of rows from all joining tables.
当一个或多个连接表上没有索引时，或者当数据库服务器必须从所有连接表中读取大量行时，就使用这种方法。
Relational databases provide the capability for the SQL statements to access information from more than one table through a joining of multiple tables.
关系数据库为sql语句提供了从一个以上的表中访问信息的能力，这是通过连接多个表来完成的。
Once the rows are sorted, the algorithm for joining the two tables is easy: the database server simply reads both sorted tables sequentially and merge all rows if they are matching.
一旦实现了对行的分类，连接两个表的算法就十分容易：数据库服务器仅仅连续地读取两个已分类表，并合并所有相匹配的行。
Typically, you create a SELECT statement, perhaps JOINing many tables together to yield a row.
通常，将创建select子句，可能需要把许多表join在一起才能得到行。
This article has explored some common database functions such as updating a database, displaying query results, joining two tables together, and filtering the results using various filter conditions.
本文已经开发了一些普通的数据库功能，例如：更新一个数据库、显示查询结果、连接两个数据表、以及使用不同的过滤条件筛选结果等。
Users can also store the XML documents and an XSLT stylesheet in separate tables and can apply a single XSLT stylesheet on multiple XML values by joining the tables.
用户也可以将XML文档和一个xslt样式表存储在不同的表中，而且可以通过连接表将单个xslt样式表应用到多个xml值。
Joining multiple tables is a powerful technique, and it can be complex when you're dealing with several large tables.
连接多个表是一种功能强大的技术，当您处理几个大型表时可能非常复杂。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
现在，当同一个查询运行时，生成的原生sQL是单个选择语句，在语句在数据库层联接来自不同目录的两个表，如图10所示。
A Query view can also join data from multiple DB2 tables and views, allowing you to join data from two NSF files indirectly by joining two separate DB2 Access views.
Query视图还可以联合多个db2表和视图中的数据，允许通过连接两个单独的DB 2Access视图，间接地联合两个NSF文件中的数据。
As we examined the tables, we found that two joining columns, customer.custid and order.custid, do not have indexes.
在检查这些表时，我们发现两个没有索引的连接列：customer .custid和order . custid。
You can do this by joining the tables and merging the information between them.
您可以联系表格，并合并表格中的信息来完成这一点。
联接两个或更多个表。
The changes can make joining 24 tables or swapping tables easy as pie (really, really awesome pie).
那些改动可使加入24表或交换表轻而易举(实的，实的实棒馅饼)。
Relational joining links tables and creates a new table from data retrieved from various tables.
交互连结相关的资料表并从不同的资料表取回资料创造新的资料表。
Relational joining links tables and creates a new table from data retrieved from various tables.
交互连结相关的资料表并从不同的资料表取回资料创造新的资料表。
应用推荐