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. Is there any way to accomplish that? - Deon