﻿IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_TanitasiOra_TanevId_IntezmenyId_OraKezdete_OraVege') BEGIN
  CREATE INDEX NCI_TanitasiOra_TanevId_IntezmenyId_OraKezdete_OraVege
    ON T_TANITASIORA (
       C_TANEVID
      ,C_INTEZMENYID
      ,C_ORAKEZDETE
      ,C_ORAVEGE
    ) 
  WHERE TOROLT = 'F'
  WITH (FILLFACTOR = 80) 
END
GO