##
WORD
IN_DOCUMENT
AT_POSITION
####
TABLE words
word CHAR(32) PRIMARY KEY
word_id INT
TABLE docs
doc_id INT PRIMARY KEY
doc_name VARCHAR
TABLE word_doc
word_id INT
doc_id INT
pos INT
####
CREATE INDEX warpspeed ON word_doc (word_id)
####
SELECT doc_id FROM word_doc WHERE word_id = ?
INTERSECT
SELECT doc_id FROM word_doc WHERE word_id = ?