
if exists(select* from sys.indexes i where i.[object_id] = OBJECT_ID('AKUZ.T_EMERGENCY_EVENT', 'U') and i.name = 'IX_EMERGENCY_EVENT_NumberIB_EventID_Includes')
	drop index IX_EMERGENCY_EVENT_NumberIB_EventID_Includes on AKUZ.T_EMERGENCY_EVENT;
go
    CREATE INDEX [IX_EMERGENCY_EVENT_NumberIB_EventID_Includes] ON [AKUZ].[T_EMERGENCY_EVENT] ([NumberIB])  INCLUDE ([AdmissionDivision]) WITH (FILLFACTOR=100, SORT_IN_TEMPDB=ON, MAXDOP = 0);
go