[MSSQL] mssql 에서 hint 사용하기

1. Hint Basic Syntax - SELECT 문에서의 HINT SYNTAX SELECT statement ::= [ ORDER BY { order_by_expression | column_position [ ASC | DESC ] } [ ,...n ]] [ OPTION ( [ ,...n ]) ] - 예제 // Merge Join을 하게하는 Hint SELECT * FROM Sales.Customer AS c INNER JOIN Sales.CustomerAddress AS ca ON c.CustomerID = ca.CustomerID WHERE TerritoryID = 5 OPTION (MERGE JOIN); 2. Hint 종류 * ..

2019.06.07