if exists(select* from sys.indexes i where i.[object_id] = OBJECT_ID('AKUZ.T_ASSOCIATED_AND_COMPLICATION_DISEASE', 'U') and i.name = 'IX_ASSOCIATED_AND_COMPLICATION_DISEASE_MedicalEpisode')
	drop index IX_ASSOCIATED_AND_COMPLICATION_DISEASE_MedicalEpisode on AKUZ.T_ASSOCIATED_AND_COMPLICATION_DISEASE;
go
	CREATE INDEX [IX_ASSOCIATED_AND_COMPLICATION_DISEASE_MedicalEpisode] ON [AKUZ].[T_ASSOCIATED_AND_COMPLICATION_DISEASE] ( [MedicalEpisode] ) WITH (MAXDOP = 0, SORT_IN_TEMPDB=ON);
go