     CONSTRAINT pk_condition_DIAGN PRIMARY KEY (exchange_id, diagnosis_id)
 );
 
+CREATE INDEX ix_condition_DIAGN_checksum_helper on condition_DIAGN (diagnosis_id, dt_received);
+
 create table condition_DIAGN_latest
 (
     exchange_id          char(36)   NOT NULL COMMENT 'links to audit.exchange table (but on a different server)',

    audit_json           mediumtext null comment 'Used for Audit Purposes',
    CONSTRAINT pk_condition_problem PRIMARY KEY (exchange_id, problem_id)
);

create table condition_problem_latest
(

    CONSTRAINT pk_condition_cds PRIMARY KEY (exchange_id, cds_unique_identifier, sus_record_type, diagnosis_seq_nbr)
);

CREATE INDEX ix_condition_cds_checksum_helper on condition_cds (cds_unique_identifier, sus_record_type, diagnosis_seq_nbr, dt_received);

create table condition_cds_latest
(
    exchange_id                    char(36)     NOT NULL COMMENT 'links to audit.exchange table (but on a different server)',
