The COMPUTE clause was introduced to get around the requirement that indexes must refer to whole columns, but it isn't limited to Java columns. You can use the COMPUTE clause to implement derived (denormalized) columns.