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
20/04/2014
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment