|
#2
happynight2010-01-05 15:52
|
有查询句；
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秒，太慢了
请问各科高手有办法快点。