Is it possible to force the creation of an automatic covering index for a subquery?
Like, 'cross join' can force the join order, 'indexed by' can force index use on a table, but it doesn't seem like there's anything to force the creation of an automatic index. The reason that I ask is that one of the queries my application uses joins two subqueries together, and the use of an automatic index can create a dramatic difference in the query performance. SQLite does choose to create an automatic index if I run 'analyze', however running 'analyze' can take a few minutes on
