On Fri, 2005-09-02 at 21:11 -0700, Dan Kennedy wrote: > In general, if your query will return a significant percentage > of the rows in your table (say 25%), you want to avoid using an > index. The LIKE syntax does this. >
More precisely: the LIKE syntax *usually* does this. With the lastest version of SQLite and if circumstances are just right, LIKE will use an index. See http://www.sqlite.org/optoverview.html#like_opt -- D. Richard Hipp <[EMAIL PROTECTED]>
