On Wed, Feb 27, 2013 at 3:16 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 2/27/2013 4:35 AM, Dominique Devienne wrote: > >> PS: Something else that should also be part of SQLite built-in is the >> optimization that col LIKE 'prefix%' queries should implicitly try to use >> an index on col. >> > > http://www.sqlite.org/**optoverview.html#like_opt<http://www.sqlite.org/optoverview.html#like_opt> Thanks for the reminder. Note though that last time I checked [1], this didn't work for a multi-column index, even if the column involved in a prefix-based like-where-clause is first in the index. --DD [1] http://stackoverflow.com/questions/11152371/how-to-improve-the-performance-of-query-with-where-and-group-by-in-sqlite/11736532#11736532 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users