SQLite only makes B-Tree indices, not hash or bitmap, and there are no clustered indices, for instance. But there are indices spanning multiple columns, there are ephemeral indices (when doing an n^2 query would be prohibitive), there are self-analytics (to gauge the efficacy of using an index in a query).
It's an entire book, so it's tough to say in a small comment box.
If you're doing queries across a 5MB database on a phone, you should be fine with or without optimizations.
If you're doing queries across a 5MB database frequently on a phone, you should think carefully about your indexes because you're responsible for battery life.
It's an entire book, so it's tough to say in a small comment box.
If you're doing queries across a 5MB database on a phone, you should be fine with or without optimizations.