On Mon, May 12, 2014 at 6:45 PM, Simon Slavin <[email protected]> wrote:
> They're not the same, Jan. This optimization is for one very specific use > of LIKE: where the match string has no wildcards except for a percent sign > at the end In theory a LIKE can be optimized if it has a fixed part at the beginning​ and any combination of wildcards after that. The fixed part is used to define a range in an index (if there is one) and then the wildcard part -if not a plain '%' taht defines 'everything'- is applied as a filter to each record in the range to narrow down the result. Now, whether this is to be preferred instead of a full table scan should be a job for the query planner. --Constantine _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
