if exists ( select * from sys.indexes i where i.object_id = object_id('AKUZ.T_VISIT', 'U') and i.name = 'IX_T_VISIT_MedicalExamination_type_')
		DROP INDEX [IX_T_VISIT_MedicalExamination_type_] ON [AKUZ].[T_VISIT];
go
CREATE INDEX [IX_T_VISIT_MedicalExamination_type_] ON [AKUZ].[T_VISIT] ([MedicalExamination], [type_])  WITH (SORT_IN_TEMPDB=ON, MAXDOP = 0);