On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy <t...@loqu8.com> wrote:
> 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). > FTS4 indices are only used with the MATCH operator. And you cannot create an index on a virtual table. So you'll either want to translate your IN into a MATCH or else search the Data_content table directly. > > Thanks. > > Respectfully, > Tim > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users