Re: [sqlite] can you speed this query up?

[Dennis Cote]

A. Pagaltzis wrote:

I can’t interpret the `EXPLAIN` output well enough to tell
whether this is likely to be faster, I’m afraid. (Actually I
don’t even understand how to tell whether/which indices are being
used; I tried creating a few and they didn’t seem to make a
discernible difference.)

  
Try using the EXPLAIN QUERY PLAN SELECT... command instead. It will show 
the order the tables are scanned and which indexes are being used.

HTH
Dennis Cote