我们看具体的例子:
一般的语句是:
USE SUBJECTDB;
SELECT *
FROM COMMON.city C
INNER JOIN PRODEFINE.PROJECTINFO P ON C.Code=P.ProjectCityCode
强制使用MERGE JOIN:
USE SUBJECTDB;
SELECT *
FROM COMMON.city C
INNER MERGE JOIN PRODEFINE.PROJECTINFO P ON C.Code=P.ProjectCityCode
强制使用HASH JOIN:
USE SUBJECTDB;
SELECT *
FROM COMMON.city C
INNER HASH JOIN PRODEFINE.PROJECTINFO P ON C.Code=P.ProjectCityCode
强制使用LOOP JOIN:
USE SUBJECTDB;
SELECT *
FROM COMMON.city C
INNER LOOP JOIN PRODEFINE.PROJECTINFO P ON C.Code=P.ProjectCityCode