ทดสอบ
Powered by Qumana
SELECT ProcID, ActID, EventID, w.ID, w.Status, w.Data, pi.ID, pi.Status, pi.StartDate, pi.Priority, pi.ExpectedDuration, pi.Folio, pi.Guid, EventInstID, EIPriority, EIExpectedDuration, EIStartDate, ActInstDestID, wh.ActInstID, AIPriority, AIExpectedDuration, AIStartDate, pf.Data, pf.Xml, af.Data, af.Xml
FROM _Worklist w (NOLOCK)
JOIN _WorklistHeader wh (NOLOCK) ON w.ProcInstID = wh.ProcInstID AND w.HeaderID = wh.ID
JOIN _ProcInst pi (NOLOCK) ON w.ProcInstID = pi.ID
JOIN _Field pf (NOLOCK) ON pi.ID = pf.ProcInstID AND wh.ProcInstFieldID = pf.ID
JOIN _Field af (NOLOCK) ON pi.ID = af.ProcInstID AND w.ActInstDestFieldID = af.ID
BEGIN TRANSACTION
SET @bErrors = 0
CREATE CLUSTERED INDEX [_Field2] ON [dbo].[_Field] ([ProcInstID] ASC, [ID] ASC )
IF( @@error <> 0 ) SET @bErrors = 1
IF( @bErrors = 0 )
COMMIT TRANSACTION
ELSE
ROLLBACK TRANSACTION
BEGIN TRANSACTION
SET @bErrors = 0
CREATE CLUSTERED INDEX [_Worklist1] ON [dbo].[_Worklist] ([User] ASC, [ProcInstID] ASC )
IF( @@error <> 0 ) SET @bErrors = 1
IF( @bErrors = 0 )
COMMIT TRANSACTION
ELSE
ROLLBACK TRANSACTION