select TOP 1 MSG_CONTENT from MESSAGES(NOLOCK) where (SEND_OUT_FLAG = '0' or SEND_OUT_FLAG = '1') and CREATE_DATE >='2008-9-11' and CREATE_DATE <'2008-9-11 9:18:04' and CMCCROUTE = 'GZMJ' group by MSG_CONTENT哎.........菜菜来着的谢谢大哥们了
调试欢乐多
where (SEND_OUT_FLAG BETWEEN 0 AND 1)
and CREATE_DATE >='2008-9-11' and CREATE_DATE <'2008-9-11 9:18:04'
and CMCCROUTE = 'GZMJ' group by MSG_CONTENT 感觉没什么优化的
最多就是OR换掉还是慢就要加上适当的索引了