报错问题
用VB做了个查询,以前用还可以,现有用经常报错,后在查询分析器上试一试,查询速度比以前慢多了,竟是42秒,所以常报错,查询句是: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
请教各位,有办法让速度快吗?