CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC] ON [dbo].[PL_REQUEST_DOC] ([REQ_ID]) GO CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC_DT] ON [dbo].[PL_REQUEST_DOC_DT] ([REQ_ID]) GO CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_PROCESS_ID] ON [dbo].[PL_REQUEST_PROCESS] ([PROCESS_ID]) GO CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID]) GO CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS_CHILD] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([PROCESS_ID]) GO CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([REQ_ID]) GO CREATE NONCLUSTERED INDEX [IDX_TL_USER_TLNANME] ON [dbo].[TL_USER] ([TLNANME]) GO