backend/sql/ingestion/05_create_indexes.sql

CREATE INDEX idx_words_word_ix ON words(word_ix);
CREATE INDEX idx_words_lexeme ON words(lexeme);
CREATE INDEX idx_links_source ON links(source);
CREATE INDEX idx_links_target ON links(target);
CREATE INDEX idx_sequences_seq_ix ON sequences(seq_ix);
CREATE INDEX idx_sequences_parent_ix ON sequences(parent_ix);