Is it possible to create an index of a table based on substring of one or more field values in DB2 ?
+1
A:
The docs imply that you can create an index on a "key-expression" rather than just a vanilla column see key-expression here.
Will A
2010-07-13 06:44:11
+1 since you're right but it's not always a good idea. Seriously, if you're going to be treating "subcolumns" as a unit, they should be split into separate columns.
paxdiablo
2010-07-13 06:52:32
Agreed - it does seem evil!
Will A
2010-07-13 06:59:07