Adding indexes on ppn and notation makes the sample query for co-occurrences a lot faster. The index on voc is optional, but helps with the other query.
I also adjusted the sample query for co-occurrences to something that would actually be used in practice, i.e. order by frequency descending and limit the results.
Adding indexes on
ppn
andnotation
makes the sample query for co-occurrences a lot faster. The index onvoc
is optional, but helps with the other query.I also adjusted the sample query for co-occurrences to something that would actually be used in practice, i.e. order by frequency descending and limit the results.