这个QUERY怎么优化啊？# Database - 数据库
h*s
1 楼
这一天，有多少人流离颠沛
这一天，有多少人家破人亡
水深火热中，让我们团结一心。
捐款：http://www.mitbbs.com/article_t/sysop/31168784.html
这一天，有多少人家破人亡
水深火热中，让我们团结一心。
捐款：http://www.mitbbs.com/article_t/sysop/31168784.html
m*e
2 楼
我不太懂SQL，但是看起来这个QUERY不太优化。请提示一下，都是INNER JOIN，怎么改
？谢谢。
SELECT dbo.tblDim_Period.Code AS MnthYr, dbo.tblDim_Account.Code AS
Account, dbo.tblDim_Prism.Code AS Prism, dbo.tblDim_Facility.Code AS
Facility,
dbo.tblDim_Product.Code AS Product, CASE WHEN dbo.
tblDim_Product.Accrual IS NULL
THEN 'ACT_ACT' ELSE dbo.tblDim_Product.Accrual END AS
ProdAccrl, dbo.tblDim_Channel.Code AS Channel, dbo.tblDim_Collateral.Code AS
Collateral,
dbo.t
？谢谢。
SELECT dbo.tblDim_Period.Code AS MnthYr, dbo.tblDim_Account.Code AS
Account, dbo.tblDim_Prism.Code AS Prism, dbo.tblDim_Facility.Code AS
Facility,
dbo.tblDim_Product.Code AS Product, CASE WHEN dbo.
tblDim_Product.Accrual IS NULL
THEN 'ACT_ACT' ELSE dbo.tblDim_Product.Accrual END AS
ProdAccrl, dbo.tblDim_Channel.Code AS Channel, dbo.tblDim_Collateral.Code AS
Collateral,
dbo.t
j*n
3 楼
have WITH (NOLOCK) hint
otherwise it pretty depends on your indexes on your join keys for such
simply query.
otherwise it pretty depends on your indexes on your join keys for such
simply query.
相关阅读