if exists(select * from sys.indexes i where i.object_id = OBJECT_ID('AKUZ.T_CARD_EPICRISIS', 'U') and i.name = 'IX_CARD_EPICRISIS_HospitalSummaryEpicris')
	drop index IX_CARD_EPICRISIS_HospitalSummaryEpicris on AKUZ.T_CARD_EPICRISIS;
go
CREATE INDEX IX_CARD_EPICRISIS_HospitalSummaryEpicris ON AKUZ.T_CARD_EPICRISIS (HospitalSummaryEpicris) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON);
GO