﻿--Migration
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_Tanitasiora_OrarendioraId_IntezmenyId_TanevId') BEGIN
  CREATE INDEX NCI_Tanitasiora_OrarendioraId_IntezmenyId_TanevId 
    ON T_TANITASIORA(C_ORARENDIORAID, C_INTEZMENYID, C_TANEVID) 
  INCLUDE (C_MEGTARTOTT) 
  WHERE TOROLT = 'F'
  WITH (FILLFACTOR = 80)
END
GO
