以下是我的存储过程可以任何一个建议我改进执行时间

问题描述

CREATE PROC [dbo].[sp_GetallEqupments]  100
@SFBId int
as
begin          --V.VesselPosition as PositionInVessal,C.Capacity as Capacity,
select EquipmentId,EquipmentName,Make,Model,
Head,RPM,
--,Quantity,MakersAddress,Yard,HullNo,YearOfManufactured,CriticalEquipments,RunningHourBased,
--InheritRunningHoursfrom,NoOfUnits,E.CreatedBy,E.CreatedDate,
S.SubFunctionalBlockName,F.FunctionalBLockName,F.FunctionalBLockId
--,Sno
  from PMS_TBL_EQUIPMENT_MASTER E
inner join dbo.PMS_TBL_SUB_FUNCTIONAL_BLOCK_MASTER S on S.SubFunctionalBlockId=E.SFBId
inner join dbo.PMS_TBL_FUNCTIONAL_BLOCK_MASTER F on F.FunctionalBLockId=S.FBId

--inner join dbo.PMS_TBL_EQUIPMENT_CAPACITY_MASTER C on C.CapacityId=E.Capacity
--inner join PMS_TBL_EUIPMENT_VESSELPOSITION_MASTER V on V.VesselPositionId=E.PositionInVessal
where E.SFBId=@SFBId and E.IsActive=1 order by EquipmentId asc
end

推荐答案

这篇关于以下是我的存储过程可以任何一个建议我改进执行时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！