SQL Server 그래픽 실행 계획은 오른쪽에서 왼쪽으로, 위에서 아래로 읽습니다. 에 의해 생성 된 출력에 의미있는 순서가 SET STATISTICS IO ON있습니까?

다음 쿼리 :

SET STATISTICS IO ON;

SELECT  *
FROM    Sales.SalesOrderHeader AS soh
        JOIN Sales.SalesOrderDetail AS sod ON soh.SalesOrderID = sod.SalesOrderID
        JOIN Production.Product AS p ON sod.ProductID = p.ProductID;

이 계획을 생성합니다.

그리고이 STATISTICS IO출력 :

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'SalesOrderDetail'. Scan count 1, logical reads 1246, physical reads 3, read-ahead reads 1277, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'SalesOrderHeader'. Scan count 1, logical reads 689, physical reads 1, read-ahead reads 685, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Product'. Scan count 1, logical reads 15, physical reads 1, read-ahead reads 14, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

그래서 나는 반복한다 : 무엇을 주는가? STATISTICS IO출력 순서가 의미 가 있거나 임의의 순서가 사용됩니까?

답변