﻿--Migration
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_TanariAtlagSuly_ErtekelesmodId_IntezmenyId_TanevId') BEGIN
  CREATE NONCLUSTERED INDEX NCI_TanariAtlagSuly_ErtekelesmodId_IntezmenyId_TanevId
    ON T_TANARIATLAGSULY (C_ERTEKELESMODID, C_INTEZMENYID, C_TANEVID)
  INCLUDE (C_SULY)
  WHERE TOROLT = 'F'
  WITH (FILLFACTOR = 80)
END
GO