Why does the optimizer not attempt to use an index when the WHERE clause uses the LIKE operator with a text column, as in:
... where myTextColumn like 'M%' My question ultimately concerns Unicode and indexing, and since these subjects are being discussed *passim* in this thread, I hope you don't mind my appending the question rather than creating a new thread. Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users