 
 
 --
+-- Name: index_studies_on_start_date; Type: INDEX; Schema: ctgov; Owner: -
+--
+
+CREATE INDEX index_studies_on_start_date ON ctgov.studies USING btree (start_date);
+
+
+--
+-- Name: index_studies_on_start_date_type; Type: INDEX; Schema: ctgov; Owner: -
+--
+
+CREATE INDEX index_studies_on_start_date_type ON ctgov.studies USING btree (start_date_type);
+
+
+--
 -- Name: index_studies_on_study_first_submitted_date; Type: INDEX; Schema: ctgov; Owner: -
 --
 



--
-- Name: index_facility_contacts_on_nct_id; Type: INDEX; Schema: ctgov_beta; Owner: -
--

CREATE INDEX index_facility_contacts_on_nct_id ON ctgov_beta.facility_contacts USING btree (nct_id);


--
-- Name: index_facility_investigators_on_nct_id; Type: INDEX; Schema: ctgov_beta; Owner: -
--

CREATE INDEX index_facility_investigators_on_nct_id ON ctgov_beta.facility_investigators USING btree (nct_id);


--
-- Name: index_id_information_on_id_type; Type: INDEX; Schema: ctgov_beta; Owner: -
--




--
-- Name: index_design_group_interventions_on_design_group_id; Type: INDEX; Schema: ctgov_beta; Owner: -
--

