regarding: "So it seems that indexes are not used at all, and that is
pretty strange"
There's a great feature in sqlite that lets you know for sure.
Prefix your query with:
EXPLAIN QUERY PLAN SELECT .....
And you can see just which, if any indices are used.
For a more detailed look at the internal "program" that your query will
generate, you can use simply
EXPLAIN SELECT .....
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
