27,579
社区成员
发帖
与我相关
我的任务
分享
create index tableA_Index on tableA(isUnderWay,delFlag,effectDate) include(workLocus)
create index index_abcds on tableA (effectDate ,isUnderWay,delFlag,workLocus );
go
select count(*) as counter
from tableA
where effectDate >= getdate()
and isUnderWay = 1
and delFlag = 0
and workLocus like '%goung bing%'