search

OHDSI / MedlineXmlToDatabase

A command line Java application for parsing MEDLINE XML files and inserting the data into a relational database
Apache License 2.0
19 stars 11 forks source link

Indexes #6

Open vojtechhuser opened 7 years ago

vojtechhuser commented 7 years ago

Did other users create a set of indexes?

I think the tables come out of the tool with no indexes.

I just did CREATE INDEX idx_one ON medcit_meshheadinglist_meshheading (pmid ASC); CREATE INDEX idx_two ON medcit_meshheadinglist_meshheading_qualifiername(pmid ASC);

If users would be willing to share their addition to the db - that would be great.

schuemie commented 7 years ago

Each table that has the pmid and pmid_version fields is created with those fields as composite primary index, which means they will also automatically be indexed.

If you want to join the MEDLINE tables with the MeSH tables you could use these indexes.