← Back to branch summary

~pixeldrama/annis/KidKo

« back to all changes in this revision

Viewing changes to Annis-Service/src/main/dist/scripts/indexes_facts.sql

  • Committer: Thomas Krause
  • Date: 2010-09-09 17:15:55 UTC
  • Revision ID: svn-v4:af1a039a-194d-0410-835c-85bbf441475e:trunk:1166
- added special join for token search on facts
- removed unused TableJoinsInWhereClauseSqlGenerator

Show diffs side-by-side

added added

removed removed

Lines of Context:
Annis-Service/src/main/dist/scripts/indexes_facts.sql
38
38
----- _=_
39
39
CREATE INDEX idx__exact_cover_:id ON facts_:id (text_ref, "left", "right");
40
40
 
 
41
-- search for token
 
42
CREATE INDEX idx__token_search_:id on facts_:id (toplevel_corpus) WHERE token_index IS NOT NULL;
 
43
 
41
44
----- 2nd query
42
45
CREATE INDEX idx__2nd_query_:id ON facts_:id (text_ref, left_token, right_token);
43
46