Hi there,
I'm trying to match a substring (case-insensitive) across multiple columns and want it to go fast; it's very slow to do a query like '... WHERE name LIKE "%fish%" OR desc LIKE "%red%" OR title LIKE "%soup%"...' Will creating a composite index that has all those columns speed up a LIKE query across all the columns in that index? That is, we'd like it to only have to do one index scan, rather than multiple table scans - will a composite key help with that? Any other suggestions for doing this are appreciated too. Thanks! Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
