Join Index

The Join Index category is located in the Root > Script > Objects category, and can contain the following items that define how join indexes are modeled for your DBMS.

Item	Description
[Common items]	The following common object items may be defined for join indexes: Add AfterCreate, AfterDrop, AfterModify BeforeCreate, BeforeDrop, BeforeModify Create, Drop Enable, EnableOwner Header, Footer Maxlen ModifiableAttributes Options, DefOptions ReversedQueries, ReversedStatements SqlAttrQuery, SqlListQuery, SqlOptsQuery For a description of each of these common items, see Common object items.
AddJoin	Specifies the SQL statement used to define joins for join indexes. Example: Table1.coln1 = Table2.coln2
EnableJidxColn	Enables support for attaching multiple columns to a join index. In Oracle 9i, this is called a bitmap join index.
JoinIndex Comment	Specifies a statement for adding a join index comment.