if exists(select* from sys.indexes i where i.[object_id] = OBJECT_ID('AKUZ.T_CDA_DGN_NOSOLOGICAL_UNIT', 'U') and i.name = 'IX_T_CDA_DGN_NOSOLOGICAL_UNIT_CdaSectionDgnMedicinalPrescriptions')
	drop index IX_T_CDA_DGN_NOSOLOGICAL_UNIT_CdaSectionDgnMedicinalPrescriptions on AKUZ.T_CDA_DGN_NOSOLOGICAL_UNIT;
go
CREATE INDEX IX_T_CDA_DGN_NOSOLOGICAL_UNIT_CdaSectionDgnMedicinalPrescriptions ON AKUZ.T_CDA_DGN_NOSOLOGICAL_UNIT(CdaSectionDgnMedicinalPrescriptions) WITH (FILLFACTOR=100);
go