索引选择的问题try:--session 1 --此需要时间大概2-3s exec(' select top 15 JobNo from pfm.dbo.JobCase where JobNo like '''+@JobNo+'%'' and CaseTypeID=''MTL'' and comid=''002'' ')--session 2 --需要超过20s exec(' select top 15 JobNo from pfm.dbo.JobCase where JobNo like '''+@JobNo+'%'' and CaseTypeID=''MTL'' and comid=''002'' and CutType=1 ')
exec('
select top 15 JobNo
from pfm.dbo.JobCase
where JobNo like '''+@JobNo+'%'' and CaseTypeID=''MTL'' and comid=''002''
')--session 2 --需要超过20s
exec('
select top 15 JobNo
from pfm.dbo.JobCase
where JobNo like '''+@JobNo+'%'' and CaseTypeID=''MTL'' and comid=''002'' and CutType=1
')