I have a table with a 16 byte column (500,000 rows), the column is indexed. When I use explain query plan in the shell, with LIKE in the WHERE clause it responds with "SCAN TABLE" whereas GLOB (or EQUALS or >= ) use the index.
LIKE 'exact hit', LIKE 'matches start%' or 'matches start _' returns "SCAN TABLE" GLOB, =, >= on the other hand return --SEARCH TABLE x USING INDEX sqlite_autoindex_x_1 LIKE is also about 100 times slower. Is this expected behaviour? using 3.24 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
