多表联合查询,怎么提高查询性能。

dys_198102 dys_198102 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
SELECT dbo.order_detail.doc_no, dbo.Product_Master.Model, dbo.Product_Master.Color,
dbo.order_detail.qty * dbo.order_detail.unit_price AS total_price,
dbo.Product_Master.description, dbo.Product_Master.stop_date,
dbo.workflow_detail.Result, dbo.workflow_detail.wf_no, dbo.So_Master.so_no,
dbo.So_Master.customer_code, dbo.So_Master.customer_name,
dbo.So_Master.so_date, dbo.So_Master.sales, dbo.order_detail.unit_price,
dbo.So_Master.trans_fee, dbo.So_Master.ignore, dbo.So_Master.financial,
dbo.So_Master.payment1, dbo.So_Master.cartage, dbo.So_Master.curr,
dbo.So_Master.tax, dbo.So_Master.TOTALAMOUNT
FROM dbo.Customer_Master INNER JOIN
dbo.So_Master ON
dbo.Customer_Master.customer_code = dbo.So_Master.customer_code INNER JOIN
dbo.workflow_master INNER JOIN
dbo.workflow_detail ON
dbo.workflow_master.wf_no = dbo.workflow_detail.wf_no INNER JOIN
dbo.Product_Master INNER JOIN
dbo.order_detail ON dbo.Product_Master.Part_no = dbo.order_detail.part_no ON
dbo.workflow_master.doc_no = dbo.order_detail.doc_no ON
dbo.So_Master.so_no = dbo.order_detail.doc_no
这是我做的最基本的查询,求高手指点,提高其查询性能
...全文
评论 14
收藏 已收藏
分享
返回顶部
dys_198102
C# 111,129 成员 642,540 内容