大家看看这是什么问题？

Superisboy 2003-12-15 11:27:28

SELECT TOP 100 PERCENT dbo.CallInfoOfProductLineAndBU_new.Period AS 月份,
dbo.BUManageRegion.RegionName AS 大区,
dbo.CodeOfProvince.ProvinceName AS 省份, dbo.CodeOfCity.CityName AS 城市,
dbo.Hospital.HospitalName AS 医院名称,
dbo.CodeOfStandardSectionOffice.name AS 标准科室,
dbo.Doctor.SectionOfficeName AS 挂牌科室, dbo.Doctor.DoctorName AS 医生姓名,
SUM(dbo.CallInfoOfProductLineAndBU_new.Call) AS Call_Num,
dbo.XJ_View_CallCard.StaffName
FROM dbo.XJ_View_CallCard LEFT OUTER JOIN
dbo.Doctor INNER JOIN
dbo.CodeOfProvince INNER JOIN
dbo.CodeOfCity ON
dbo.CodeOfProvince.ProvinceCode = dbo.CodeOfCity.ProvinceCode INNER JOIN
dbo.Hospital INNER JOIN
dbo.BUManageRegion INNER JOIN
dbo.RegionManageDoctor2 ON
dbo.BUManageRegion.RegionRowID = dbo.RegionManageDoctor2.RegionRowID INNER
JOIN
dbo.CodeOfStandardSectionOffice ON
dbo.RegionManageDoctor2.SectionOfficeCode = dbo.CodeOfStandardSectionOffice.SectionOfficeCode
ON dbo.Hospital.HospitalRowID = dbo.RegionManageDoctor2.HospitalRowID ON
dbo.CodeOfCity.CityCode = dbo.Hospital.CityCode ON
dbo.Doctor.DoctorRowID = dbo.RegionManageDoctor2.DoctorRowID ON
dbo.XJ_View_CallCard.HospitalId = dbo.Doctor.HospitalRowID RIGHT OUTER JOIN
dbo.CallInfoOfProductLineAndBU_new ON
dbo.RegionManageDoctor2.DoctorRowID = dbo.CallInfoOfProductLineAndBU_new.DoctorRowID
GROUP BY dbo.CallInfoOfProductLineAndBU_new.Period,
dbo.BUManageRegion.RegionName, dbo.CodeOfProvince.ProvinceName,
dbo.CodeOfCity.CityName, dbo.Hospital.HospitalName,
dbo.CodeOfStandardSectionOffice.name, dbo.Doctor.SectionOfficeName,
dbo.Doctor.DoctorName, dbo.XJ_View_CallCard.StaffName
运行了七分四十九分钟，在企业管理器中显示"超时已过期",怎么优化啊？

...全文