     audit_json           mediumtext null comment 'Used for Audit Purposes',
     CONSTRAINT pk_condition_problem PRIMARY KEY (exchange_id, problem_id)
 );
+
+CREATE INDEX ix_condition_problem_checksum_helper on condition_problem (problem_id, dt_received);
 
 create table condition_problem_latest
 (

    CONSTRAINT pk_condition_DIAGN PRIMARY KEY (exchange_id, diagnosis_id)
);

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_cds_tail PRIMARY KEY (exchange_id, cds_unique_identifier, sus_record_type)
);

CREATE INDEX ix_condition_cds_tail_checksum_helper on condition_cds_tail (cds_unique_identifier, sus_record_type, dt_received);


create table condition_cds_tail_latest
(
