Indexing Java Objects

• Indexes must be on columns, not expressions

• Java object columns are OK

  • Uses toString() and compareTo() methods

• Use COMPUTE clause for Java fields

  • COMPUTE ( JIndexDemo >> integer1 )
  • New feature, read-only

Previous slide

Next slide

Back to first slide

View graphic version

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.