Indexing Java Objects - 2

CREATE TABLE java_index_demo

( pkey INTEGER NOT NULL,

JIndexDemo IndexDemo NOT NULL,

compute_integer1 INTEGER

COMPUTE ( JIndexDemo >> integer1 )

NOT NULL,

ordinary_integer INTEGER NOT NULL,

PRIMARY KEY ( pkey ) );

CREATE INDEX ix_JIndexDemo

ON java_index_demo ( JIndexDemo );

CREATE INDEX ix_compute_integer1

ON java_index_demo ( compute_integer1 );

CREATE INDEX ix_ordinary_integer

ON java_index_demo ( ordinary_integer );

Previous slide

Next slide

Back to first slide

View graphic version

This example shows that the same syntax is used to define indexes on Java object columns, computed columns and ordinary Watcom SQL columns.