Re[2]: [sqlite] Index usage with LIKE queries

dc> If you are building an email indexing system, you problem dc> want to use Full Text Search with fts3, not the LIKE dc> operator. See dc>http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex Thanks, interesting, but seems it's not my case, cause I'm doing search by partial name/email

Re: [sqlite] Index usage with LIKE queries

<[EMAIL PROTECTED]> wrote: > I thought I can create two separate indexes: on name and on email, > and when I execute a query with "name LIKE 'value' OR email > LIKE 'value'" both indexes would be used. > If you are building an email indexing system, you problem want to use Full Text Search with

Re: [sqlite] Index usage with LIKE queries

<[EMAIL PROTECTED]> wrote: > IT> LIKE is case-insensitive by default. To have it use your index, you need > IT> to either make the index case-insensitive: > IT> > IT> CREATE INDEX test_name ON test (name COLLATE NOCASE); > > Sorry, tried to create the index this way, but it > still isn't used

[sqlite] Index usage with LIKE queries

Hi I'm trying to get index used with LIKE queries: CREATE TABLE test (name STRING); CREATE INDEX test_name ON test (name); EXPLAIN QUERY PLAN SELECT * FROM test WHERE name = 'aaa'; The output is: 0|0|TABLE test WITH INDEX test_name i.e. when LIKE is not used, the index is involved, everything is