specifies one or more
DBMS-specific clauses that can be appended to the end of an SQL CREATE
INDEX statement.
Details
This option enables
you to add DBMS-specific clauses to the end of the CREATE INDEX statement.
The interface passes the CREATE INDEX statement and its clauses to
the DBMS, which executes the statement and creates the DBMS index.
Example
In the following example,
a Hive index is created with the value of the DBCREATE_INDEX_OPTS=
“as 'compact' with deferred rebuild” option
appended to the CREATE INDEX statement:
create index "COL1_1A03" on "TKTS002_1A03"{options DBCREATE_INDEX_OPTS="as 'compact'
with deferred rebuild"}("COL1")
The following CREATE
INDEX statement is passed to the DBMS in order to create the index:
create index 'COL1_1A03' on table 'TKTS002_1A03'('COL1') as 'compact' with
deferred rebuild