Define a multi-tenant Index

An index on a multi-tenant table is automatically a multi-tenant index. To define an index, mtcustomer_index, as a multi-tenant index:

CREATE INDEX mtcustomer_index ON mtcustomer (cust_num)
FOR TENANT DEFAULT USING INDEX AREA "Misc_Index_Area"
;