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

if exists(select* from sys.indexes i where i.[object_id] = OBJECT_ID('AKUZ.T_CDA_CONSULTATION', 'U') and i.name = 'IX_CDA_CONSULTATION_MedExam')
	drop index IX_CDA_CONSULTATION_MedExam on AKUZ.T_CDA_CONSULTATION;
go
CREATE NONCLUSTERED INDEX [IX_CDA_CONSULTATION_MedExam] ON [AKUZ].[T_CDA_CONSULTATION] ([MedicalExamination])  WITH (FILLFACTOR = 95)
go
