On Mar 31, 2006, at 12:04 AM, Marco Bambini wrote:
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/
Thanks for the pointer to that page
The LIKE optimization is about what I had expected but couldn't
actually see happening in the quick bunch of EXPLAINS I did.
_______________________________________________
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>
