USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX IX_gMenu_Group_Id_Menu
ON [dbo].[gMenu_Group] ([Id_Menu])

GO



USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX Contact_Header_Flag_Approval1
ON [dbo].[Contact_Header] ([Flag_Approval1])
INCLUDE ([Id_Contact],[No_Proposal],[Nama],[NPWP],[Bagian],[Transfer_Ya],[Rek_No],[Rek_Nama],[Kode_Bank],[Bank_Cabang],[Bank_Lokasi],[Id_Approval1],[Tgl_Approval1],[Id_Approval2],[Tgl_Approval2],[Flag_Approval2],[Id_Approval3],[Tgl_Approval3],[Flag_Approval3],[Id_Approval4],[Tgl_Approval4],[Flag_Approval4],[Status],[Change_By],[Change_Date])
GO



USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX Contact_Header_Flag_Approval2
ON [dbo].[Contact_Header] ([Flag_Approval2])
INCLUDE ([Id_Contact],[No_Proposal],[Nama],[NPWP],[Bagian],[Transfer_Ya],[Rek_No],[Rek_Nama],[Kode_Bank],[Bank_Cabang],[Bank_Lokasi],[Id_Approval1],[Tgl_Approval1],[Id_Approval2],[Tgl_Approval2],[Flag_Approval1],[Id_Approval3],[Tgl_Approval3],[Flag_Approval3],[Id_Approval4],[Tgl_Approval4],[Flag_Approval4],[Status],[Change_By],[Change_Date])
GO



USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX Contact_Header_Flag_Approval3
ON [dbo].[Contact_Header] ([Flag_Approval3])
INCLUDE ([Id_Contact],[No_Proposal],[Nama],[NPWP],[Bagian],[Transfer_Ya],[Rek_No],[Rek_Nama],[Kode_Bank],[Bank_Cabang],[Bank_Lokasi],[Id_Approval1],[Tgl_Approval1],[Id_Approval2],[Tgl_Approval2],[Flag_Approval1],[Id_Approval3],[Tgl_Approval3],[Flag_Approval2],[Id_Approval4],[Tgl_Approval4],[Flag_Approval4],[Status],[Change_By],[Change_Date])
GO



USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX Contact_Header_Flag_Approval4
ON [dbo].[Contact_Header] ([Flag_Approval4])
INCLUDE ([Id_Contact],[No_Proposal],[Nama],[NPWP],[Bagian],[Transfer_Ya],[Rek_No],[Rek_Nama],[Kode_Bank],[Bank_Cabang],[Bank_Lokasi],[Id_Approval1],[Tgl_Approval1],[Id_Approval2],[Tgl_Approval2],[Flag_Approval1],[Id_Approval3],[Tgl_Approval3],[Flag_Approval2],[Id_Approval4],[Tgl_Approval4],[Flag_Approval3],[Status],[Change_By],[Change_Date])
GO
