With the lastest version of SQLite (version 3) and if circumstances
are just right, LIKE will use an index.
See http://www.sqlite.org/optoverview.html#like_opt
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Mar 31, 2006, at 9:49 AM, Carlos M wrote:
On Mar 31, 2006 8:06 AM, Marco Bambini wrote:
Unfortunately that does not make any difference if the
search is made using 'LIKE' because SQLite will ignore the
index and will perform a full table scan. See 5.5.1 at:
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
The document refers to version 2.8.6 (10 September 2003), a lot of
changes occurs in sqlite since that version.
Yes, I know it's for an old version, but the part I was referring was
ONLY to using the 'LIKE' with a index. Does SQLite currently uses an
index (if present) when the search is made with 'LIKE' or performs a
full table scan?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|