IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[RC_CLI_CONV_RC_CLI_AUDIT]') AND name = N'IX_RC_CLI_CONV_RC_CLI_AUDIT_CD_EMP_CD_CLI')
	DROP INDEX [IX_RC_CLI_CONV_RC_CLI_AUDIT_CD_EMP_CD_CLI] ON [dbo].[RC_CLI_CONV_RC_CLI_AUDIT]
GO

CREATE NONCLUSTERED INDEX [IX_RC_CLI_CONV_RC_CLI_AUDIT_CD_EMP_CD_CLI]
ON [dbo].[RC_CLI_CONV_RC_CLI_AUDIT] ([CD_EMP],[CD_CLI])
INCLUDE ([VLR_DEB],[VLR_CRED],[DT_CAD],[CD_USU],[TRANSACAO],[NM_PROGRAMA],[HOST])
GO


