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)表时,将必须在内部访存的行数减到最少。
应用推荐