拜托各位大侠帮我优化一个存储过程,急!!!
如题
===========================================================================
CREATE PROCEDURE selectAllOpenDocumentsInfo
@user varchar(50),@dept varchar(50),@lv varchar(50)
AS
select a.documentID,a.documentName,e.typeName,a.documentInfo,a.VesionIDUser,a.vesionId,a.vesionDate,a.documentSize,a.documentSend,a.documenttype,
a.documenturl
from FeiliOA_DocumentManage_DocumentInfo a,FeiliOA_DocumentManage_TypeLookUser b,
FeiliOA_DocumentManage_TypeLookDept c,FeiliOA_DocumentManage_TypeLookLv d,
FeiliOA_DocumentManage_TypeInfo e
where ((a.DocumentType=b.typeID and (b.lookuser=@user or b.lookuser='ALL'))
or (a.DocumentType=c.typeID and (c.lookdept=@dept or c.lookdept='ALL'))
or(a.DocumentType=d.typeID and (d.looklv=@lv or d.looklv='ALL'))) and e.typeid=a.documenttype and a.documentStatic='a'
group by a.documentID,a.documentName,e.typeName,a.documentInfo,a.VesionIDUser,a.vesionId,a.vesionDate,a.documentSize,a.documentSend,
a.documenttype,a.documenturl