--SELECT * FROM view_Contact WHERE Charindex('PRIB',dbo.func_GetOtoritasList(Id_Contact))<>0 AND Flag_Approval1=0
/*
Missing Index Details from SQLQuery282.sql - eli-db10\grpinsurance.GrpInsurance (pribadi (147))
The Query Processor estimates that implementing the following index could improve the query cost by 27.9617%.
*/


USE [GrpInsurance]
GO
CREATE NONCLUSTERED INDEX IX_DCP_Terbit_Contact_Id_Contact
ON [dbo].[DCP_Terbit_Contact] ([Id_Contact])

GO

