if exists (select * from sys.indexes i where i.object_id = object_id('AKUZ.T_DEATH_INFO_HISTORY', 'U') and i.name = 'IX_DEATH_INFO_HISTORY_AmbulanceCard')
	DROP INDEX IX_DEATH_INFO_HISTORY_AmbulanceCard ON AKUZ.T_DEATH_INFO_HISTORY;
go
CREATE INDEX IX_DEATH_INFO_HISTORY_AmbulanceCard ON AKUZ.T_DEATH_INFO_HISTORY(AmbulanceCard) WITH ( FILLFACTOR = 90,  SORT_IN_TEMPDB = ON, MAXDOP = 0 );
go
if exists (select * from sys.indexes i where i.object_id = object_id('AKUZ.T_SCHET_USL', 'U') and i.name = 'IX_SCHET_USL_MedicalService')
	DROP INDEX IX_SCHET_USL_MedicalService ON AKUZ.T_SCHET_USL;
go
	CREATE INDEX [IX_SCHET_USL_MedicalService] ON [AKUZ].[T_SCHET_USL] (MedicalService) WITH (FILLFACTOR = 90,	SORT_IN_TEMPDB = ON,MAXDOP = 0);
go