sql执行的慢该怎么去优化？

最新推荐文章于 2024-08-07 20:46:27 发布

haunting_1

最新推荐文章于 2024-08-07 20:46:27 发布

阅读量136

点赞数

文章标签： sql 数据库 sqlserver

本文链接：https://blog.csdn.net/haunting_1/article/details/115175848

版权

一个查询120万条数据的SQL语句执行耗时17分钟，急需优化。该查询涉及多层子查询和联接操作。优化策略可能包括：减少子查询、优化联接方式、创建索引、调整查询语句等。寻求SQL优化建议。

摘要由CSDN通过智能技术生成

数据有120w，查数据要差不多17分钟，要怎么去优化它啊，求大佬帮忙！

SELECT '餐饮' as 渠道,TBStoreChannelDMS.ChannelName as 标准渠道,(select name from middleData.dbo.SystemUserDepartmentSteve where id=
(select FK_SystemUserDepartment_ID from middleData.dbo.SystemUserDepartmentSteve where ID=(select FK_SystemUserDepartment_ID from middleData.dbo.SystemUserDepartmentSteve
where ID=(select FK_SystemUserDepartment_ID from middleData.dbo.SystemUserDepartmentSteve where ID=(select Top 1 FK_SystemUserDepartment_Create_ID
from TBStoreDMS where id=c.id))))) as 大区,
(select Name from middleData.dbo.SystemUserDepartmentSteve where ID=(select FK_SystemUserDepartment_ID from middleData.dbo.SystemUserDepartmentSteve
where ID=(select FK_SystemUserDepartment_ID from middleData.dbo.SystemUserDepartmentSteve where ID=(select Top 1 FK_SystemUserDepartment_Create_ID
from TBStoreDMS where id=c.id)))) as 战区,
(select Nam