这个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.
相关阅读
a simple question about T-SQL how to particially delete record in sql server --- there is no field for autonumberhow to open .db file?Re: recursive sql?Managment server in Oracle8i请推荐关于PHP和mySQL实现小database的网站。Help!-VB-Addnew?Problem when using SQL " Insert...." to AutoNumber.怎样实现WWW Client的安全登录？how to create user in Oracle?[转载] JDBC 处理日期的问题(日期插入数据库)Help! about Access2000 and VB6help on store procedure of db2backup and refresh a web site serverRe: how to separate the table ---PSmysql Linux installation problemIs "Dim mydb as database" a user-defined datatypeDoes VB works with Oracledatabase triggersDB2 download