﻿--Migration
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'NCI_TanitasiOraTulajdonsag_IntezmenyId_TanevId_TanitasioraId_OraTulajdonsagId')
    CREATE NONCLUSTERED INDEX NCI_TanitasiOraTulajdonsag_IntezmenyId_TanevId_TanitasioraId_OraTulajdonsagId
    ON T_TANITASIORATULAJDONSAG(
        C_INTEZMENYID, 
        C_TANEVID, 
        C_TANITASIORAID, 
        C_ORATULAJDONSAGID
    )
    INCLUDE(TOROLT)
    WITH (FILLFACTOR = 80)