[sqlite] Re: sqlite too slow for me?

[Igor Tandetnik]

Joe Wilson <developir-/[EMAIL PROTECTED]> wrote:
SELECT col2 FROM t
WHERE +col1='foobar' AND col4='foobarfoobarfoobarfoob';
With the above where clause,
the unique index (col4, col5, col1) will be used instead of
the less efficient PRIMARY KEY(col1, col2, col3, col4, col5).

Shouldn't the original query be able to use UNIQUE(col1, col4, col5) 
index?

Igor Tandetnik