Re:SQL Indexing and Tuning e-Book
by quux on Sunday December 16, 2012 @06:04PM
(#4929951)
Looks very interesting, can anyone say if this material also applies to SQLite?
[ Parent
| on HN ]
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.