Tim, >Queries using GLOB do use the index on the column in question (i.e. >optimization is attempted) >Queries using LIKE do not use that index if the LIKE operator has been >overridden.
Sorry but GLOB doesn't use an index either if LIKE/GLOB has been overloaded. This is consistent with the docs and the output of Explain query plan for both variants when an extension is active and overloads LIKE/GLOB. Things can be different with a custom built of SQLite, where native LIKE/GLOB itself has been modified. With custom code, all bets are off. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users