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_PL_REQUEST_PROCESS_CHILD_TLNAME] ON [dbo].[PL_REQUEST_PROCESS_CHILD]([TLNAME])

CREATE NONCLUSTERED INDEX [IDX_TL_SYS_ROLE_MAPPING] ON [dbo].[TL_SYS_ROLE_MAPPING]([TLNAME])
INCLUDE([ROLE_OLD],[ROLE_NEW])