On 18 Apr 2010, at 7:08pm, Mike Goins wrote: >> Also, I don't recall your saying whether a single composite index was faster >> than separate indexes? Is it? >> >> Regards >> Tim Romano > > Interesting suggestion. Separate indexes look to be slightly faster > than the composite. Separate indexes seem more significant in > retrieving data that is at the end of the table.
I don't understand why. The documentation for SQLite says that both GLOB 'a*' and LIKE 'a%' are translated into two clauses for WHERE. If that's the case, and if the query planner is working right, I don't understand why a composite index isn't much faster than the separate indexes. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users