Chapter 3 DBMS Reference Guide

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.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.