On Wed, Dec 16, 2015 at 9:17 AM, Deon Brewis <deonb at outlook.com> wrote: > Is it possible to have an index on a computer value? > > E.g. I have a 40 byte value in one of my columns. I only want an index over > the first 4 bytes of it. > > However, I don't really want to repeat those 4 bytes inside another column on > the main table.
See http://sqlite.org/expridx.html Ambrus