﻿IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_Gondviselo_ElozotanevirekordId') BEGIN
  CREATE NONCLUSTERED INDEX NCI_Gondviselo_ElozotanevirekordId
    ON T_GONDVISELO (ELOZOTANEVIREKORDID)
	INCLUDE (C_INTEZMENYID)
  WITH (FILLFACTOR = 80)  
END
GO

IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_Telefon_ElozotanevirekordId') BEGIN
  CREATE NONCLUSTERED INDEX NCI_Telefon_ElozotanevirekordId
    ON T_TELEFON (ELOZOTANEVIREKORDID)
	INCLUDE (C_INTEZMENYID)
  WITH (FILLFACTOR = 80)  
END
GO

IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_Cim_ElozotanevirekordId') BEGIN
  CREATE NONCLUSTERED INDEX NCI_Cim_ElozotanevirekordId
    ON T_CIM (ELOZOTANEVIREKORDID)
	INCLUDE (C_INTEZMENYID)
  WITH (FILLFACTOR = 80)  
END
GO

IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_Email_ElozotanevirekordId') BEGIN
  CREATE NONCLUSTERED INDEX NCI_Email_ElozotanevirekordId
    ON T_EMAIL (ELOZOTANEVIREKORDID)
	INCLUDE (C_INTEZMENYID)
  WITH (FILLFACTOR = 80)  
END
GO
