We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

[Users] OpenClinica Data Warehouse Script

This script will create indexes on certain tables that will help the time to complete the execution of the query considerably. If you can not see the attached file, please go to this link to download it,

http://www.openclinica.org/dokuwiki/doku.php?id=ocknownissues:openclinica2.2.1ki

Thanks,
Paul

Create Indexes.txt
CREATE INDEX item_id_item_group_metadata_table ON item_group_metadata USING btree (item_id);
CREATE INDEX crf_version_id_item_group_metadata_table ON item_group_metadata USING btree (crf_version_id);
CREATE INDEX item_group_id_item_group_table ON item_group USING btree (item_group_id);
CREATE INDEX status_id_item_data_table ON item_data USING btree (status_id);
CREATE INDEX status_id_event_crf_table ON event_crf USING btree (status_id);
CREATE INDEX item_id_item_data_table ON item_data USING btree (item_id);
CREATE INDEX event_crf_id_item_data_table ON item_data USING btree (event_crf_id);
CREATE INDEX response_set_id_item_form_metadata_table ON item_form_metadata USING btree (response_set_id);
CREATE INDEX crf_id_event_definition_crf_table ON event_definition_crf USING btree (crf_id);
This discussion has been closed.