Let's say I have a table Data_content(term TEXT UNIQUE) which has an indexed column 'term'. I then create an FTS4 table using
CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term); If I later search using SELECT * FROM Data WHERE term IN (...), does it use the indexes generated in Data_content, or do I have to generate another set (or search Data_content directly). Thanks. Respectfully, Tim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users