Re: [sqlite] Index and General Optimization Question

[Kurt Welgehausen]

Currently, indices are not used to look up either term
in an OR expression.

See <http://www.sqlite.org/php2004/page-052.html>.

You could build 2 separate 5-column indices and use a
union.

Regards