IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_CDA_AMBS_DGN_V4]') AND name = N'IX_CDA_AMBS_DGN_V4_CdaSectionEpicrisisAmbsInfoV4')
DROP INDEX [IX_CDA_AMBS_DGN_V4_CdaSectionEpicrisisAmbsInfoV4] ON [AKUZ].[T_CDA_AMBS_DGN_V4]
GO
CREATE NONCLUSTERED INDEX [IX_CDA_AMBS_DGN_V4_CdaSectionEpicrisisAmbsInfoV4] ON [AKUZ].[T_CDA_AMBS_DGN_V4] ([CdaSectionEpicrisisAmbsInfoV4]) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON)
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_CDA_SECTION_RESCONS_CONS_DISP]') AND name = N'IX_CDA_SECTION_RESCONS_CONS_DISP_CdaConsultationInDispensaryProtocol')
DROP INDEX [IX_CDA_SECTION_RESCONS_CONS_DISP_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_RESCONS_CONS_DISP]
GO
CREATE NONCLUSTERED INDEX [IX_CDA_SECTION_RESCONS_CONS_DISP_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_RESCONS_CONS_DISP] ([CdaConsultationInDispensaryProtocol]) INCLUDE (type_) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON)
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_CDA_SECTION_ANAM]') AND name = N'IX_CDA_SECTION_ANAM_CdaConsultationInDispensaryProtocol')
DROP INDEX [IX_CDA_SECTION_ANAM_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_ANAM]
GO
CREATE NONCLUSTERED INDEX [IX_CDA_SECTION_ANAM_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_ANAM] ([CdaConsultationInDispensaryProtocol]) INCLUDE (type_) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON)
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[AKUZ].[T_CDA_SECTION_LANAM]') AND name = N'IX_CDA_SECTION_LANAM_CdaConsultationInDispensaryProtocol')
DROP INDEX [IX_CDA_SECTION_LANAM_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_LANAM]
GO
CREATE NONCLUSTERED INDEX [IX_CDA_SECTION_LANAM_CdaConsultationInDispensaryProtocol] ON [AKUZ].[T_CDA_SECTION_LANAM] ([CdaConsultationInDispensaryProtocol]) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON)
GO