-- PUBS INDEXES-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
-- critical idx:
create index idxCovering on machine_annotations_pubs (filename_short,token);
create index idxToken on machine_annotations_pubs(token);
create index idxShortFile on machine_annotations_pubs (filename_short);
create index idxMatchSource on machine_annotations_pubs (match_source);

-- useful idx:
create index idxMatchValue on machine_annotations_pubs (match_value);
create index idxMatchKVPair on machine_annotations_pubs (match_source, match_value);
create index idxShortAnnot on machine_annotations_pubs (annot_type_short);

create index kwdIdx on keywords(keyword);
create index pubIdIdx on authors(pub_id);
create index pubIdIdx on refs(pub_id);
create index jtitleIdx on pubs(journal_title);
create index fileIdx on pubs(filepath);
