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 fine. Then I'm trying LIKE query: EXPLAIN QUERY PLAN SELECT * FROM test WHERE name LIKE 'aaa'; The output is: 0|0|TABLE test i.e. the index is not used. Why? What am I doing wrong?
Thanks, telega ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
