﻿IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_KKTanarVegzettseg_AlkalmazottId_TanevId_IntezmenyId') BEGIN
  CREATE INDEX NCI_KKTanarVegzettseg_AlkalmazottId_TanevId_IntezmenyId 
    ON T_KKTANARVEGZETTSEG (C_ALKALMAZOTTID,C_TANEVID,C_INTEZMENYID)
  WITH (FILLFACTOR = 80)
END
GO