Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : DBA use cases : Define a multi-tenant Index
 

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"
;