有查询句；
SELECT  flow as '标记' ,reccode as '发票号',PatName as '病人姓名',MedName as '检查项目',SelfMoney
as '金额',DocName as '医师',OpeName as '收费员',AddTime as '交费时间'
 FROM Recipeview where sendope is null  and executeoffice=4001  order by flow desc
用了42秒，太慢了
请问各科高手有办法快点。

把条件改成 executeoffice=4001   AND sendope is null  
另外可以考虑的是 建索引 改成存储过程 你试下

试过了，还是一样

留个QQ号 晚上有空聊