Indexes

[vojtechhuser]

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]

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.