Breaking News
Loading...
20/04/2014

Bắt SQL Server join theo thứ tự mình muốn

SELECT b.TRID, b.ITEMCD, a.ITEMNAME, b.UOMCD,
       c.UOMNAME, b.QTY, b.RATE, b.AMOUNT
FROM   [dbo].[tbl_ITEMDTLS] AS a
       INNER JOIN  [dbo].[tbl_SBILL] AS b ON a.ITEMCD = b.ITEMCD
       INNER JOIN  [dbo].[tbl_UOMDTLS]  AS c ON b.UOMCD  = c.UOMCD
OPTION ( QUERYRULEOFF JoinCommute);
http://sqlknowledgebank.blogspot.com/2014/03/join-order-cans-increase-performance.html

0 comments:

Post a Comment

 
Toggle Footer