Have you measured the speed to see if your preferred query plan really is faster than the query plan that SQLite actually generates?
Have you measured the speed to see if your preferred query plan really is faster than the query plan that SQLite actually generates?