kreta/Kreta.DataAccess.Migrations/Scripts/Archive/20190614133656_DB_805/DB_805.sql

--Migration
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_HaziFeladatok_OsztalyCsoportId_Hatarido' ) BEGIN
  CREATE INDEX NCI_HaziFeladatok_OsztalyCsoportId_Hatarido 
    ON T_HAZIFELADATOK (C_OSZTALYCSOPORTID, C_HATARIDO) 
  INCLUDE (C_TANEVID, C_INTEZMENYID) 
  WHERE TOROLT = 'F' 
  WITH (FILLFACTOR = 80)
END
GO