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.