I think storing index prefix counts would only make sense in a special kind
of 'statistical' index, where you would store count(x IS NOT NULL), sum(x),
sum(x^2) so that usual statistical functions can be computed optimally.
For a table count, I think it would make sense.
Sent from: http://sqlite.1065341.n5.nabble.com/
sqlite-users mailing list