haunting_1的博客

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

数据有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=...