Ran into an annoying deficiency of SQLite's query optimizer.
This won't use an index on x:
SELECT min(x), max(x) FROM A
You can write it this way to take advantage of an index:
SELECT (SELECT min(x) FROM A), (SELECT max(x) FROM A)
It's implied here:
sqlite.org/optoverview.ht
