SQLite Forum

Views with UNION ALL
Login
I don't think any amount of scouring will reveal a commitment to any particular query plans for particular queries.

There is an easy way to find out what will be done for a query in the shell. Enter:<code>
  EXPLAIN SELECT ... ;
</code>, then examine the output.