-- CASES INDEXES-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
-- critical idx:
-- create index idxCovering on annotations (filename_short,token);
create index idxCovering2 on annotations (filename_short, token, start_idx, end_idx);
create index idxToken on annotations(token);
create index idxShortFile on annotations (filename_short);
-- tf 
create index idxTokPos on lookup_term_frequency (token,pos);

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


-- case feature indexes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
create index idxIsPhi on feature_matrix(is_phi);
create index idxShortFile on feature_matrix(filename_short);
create index idxStartIdx on feature_matrix(start_idx);

-- other 
create index idxStartIdx on human_annotations(start_idx);
create index idxEndIdx on human_annotations(end_idx);

