This join method is usually used when no index is available on the join columns for the 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.
当一个或多个连接表上没有索引时,或者当数据库服务器必须从所有连接表中读取大量行时,就使用这种方法。
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.
当一个或多个连接表上没有索引时,或者当数据库服务器必须从所有连接表中读取大量行时,就使用这种方法。
应用推荐