|
#2
jxawgyl2010-09-30 09:21
|
如何更快的查询数据
现有四张表RecipeList，Outpatient ，Recipe，MedicineInspect ，查询每张表只要0.1秒时间，现建张视图表查询却要5分多，其如下：SELECT dbo.Outpatient.PatCode, dbo.Outpatient.PatName, dbo.Outpatient.Age,
dbo.Outpatient.Sex, dbo.Outpatient.PatKindName, dbo.Outpatient.MedInsName,
dbo.Outpatient.OffCode, dbo.MedicineInspect.MedName,
dbo.MedicineInspect.MedSpec, dbo.MedicineInspect.StoreUnit,
dbo.MedicineInspect.RoomUnit, dbo.MedicineInspect.ConvertUnit,
dbo.MedicineInspect.MedSortCode, dbo.MedicineInspect.FinSortCode,
dbo.MedicineInspect.PhaSortCode, dbo.MedicineInspect.MedModelCode,
dbo.MedicineInspect.FivePen, dbo.MedicineInspect.Spell,
dbo.MedicineInspect.Grade, dbo.MedicineInspect.MedSortName,
dbo.MedicineInspect.FinSortName, dbo.MedicineInspect.PhaSortName,
dbo.MedicineInspect.MedModelName, dbo.MedicineInspect.TendSortName,
dbo.MedicineInspect.NongYi, dbo.MedicineInspect.ExecuteOffice,
dbo.MedicineInspect.Sort, dbo.RecipeList.RecCode, dbo.RecipeList.Flow,
dbo.RecipeList.MedCode, dbo.RecipeList.Number, dbo.RecipeList.RoomPrice,
dbo.RecipeList.SendOpe, dbo.RecipeList.Sendtime, dbo.RecipeList.BackDrugOpe,
dbo.RecipeList.BackDrugTime, dbo.RecipeList.BackChaOpe,
dbo.RecipeList.ChargeOpe, dbo.RecipeList.CancelOpe, dbo.RecipeList.RoomCode,
dbo.RecipeList.AddTime, dbo.RecipeList.DocCode, dbo.RecipeList.DocName,
dbo.RecipeList.CancelSign, dbo.RecipeList.PreBackNum, '西药房' AS OffName,
dbo.RecipeList.InsSign, dbo.RecipeList.AllMoney, dbo.RecipeList.SelfMoney,
dbo.Operator.OpeName, dbo.Outpatient.OpeCode, dbo.Office.OffName AS OffName1,
dbo.RecipeList.CheckSign, dbo.Recipe.YBRecCode
FROM dbo.RecipeList INNER JOIN
dbo.Outpatient INNER JOIN
dbo.Recipe ON dbo.Outpatient.PatCode = dbo.Recipe.PatCode ON
dbo.RecipeList.RecCode = dbo.Recipe.RecCode INNER JOIN
dbo.MedicineInspect ON
dbo.RecipeList.MedCode = dbo.MedicineInspect.MedCode INNER JOIN
dbo.Operator ON dbo.Outpatient.OpeCode = dbo.Operator.OpeCode INNER JOIN
dbo.Office ON dbo.Outpatient.OffCode = dbo.Office.OffCode
请教各位应如何修改?
晕了
