if exists(select* from sys.indexes i where i.[object_id] = object_id('AKUZ.T_MEDICAL_EPISODE', 'U') and i.name = 'IX_MEDICAL_EPISODE_AmbulanceCard_OutcomeRecord_Mkb')
	DROP INDEX IX_MEDICAL_EPISODE_AmbulanceCard_OutcomeRecord_Mkb ON AKUZ.T_MEDICAL_EPISODE;
GO
CREATE INDEX [IX_MEDICAL_EPISODE_AmbulanceCard_OutcomeRecord_Mkb] ON [AKUZ].[T_MEDICAL_EPISODE] ([AmbulanceCard], [OutcomeRecord], [Mkb])  WITH (FILLFACTOR=100, SORT_IN_TEMPDB=ON);
GO
