Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | RELATION_INDEX |
| Short Name | RIN |
| View Name | CI_RELATION_INDEXES |
| Description | The definition of an index on a table or snapshot, as opposed to a |
| cluster index. | |
| Sub-type of | INDEX |
| Versioning: | Belongs to: SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
SNAPSHOT_DEFINITION_REFERENCE TABLE_DEFINITION_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_IND |
| Changes: | Summary of changes to RELATION_INDEX in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| SNAPSHOT_DEFINITION_REFERENCE | N |
Prompt: Materialized View
Transferable only if null |
Must be to optimise access to one and only one SNAPSHOT_DEFINITION | 48 |
| TABLE_DEFINITION_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be to optimise access to one and only one TABLE_DEFINITION | 48 |
| FOREIGN_KEY_REFERENCE | Y | Prompt: Foreign Key | May be supporting joins over one and only one FOREIGN_KEY_CONSTRAINT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of the index is complete and ready to be used by the generators
Prompt: Complete ? Uppercase Defined on IND supertype | YESNO | Y |
| COMPUTE_STATISTICS_FLAG | VARCHAR2(1) | N | Indicates whether statistics are to be collected on creation of index
Prompt: Compute Statistics ? Uppercase Defined on IND supertype | YESNO | N |
| INDEX_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the INDEX is a CLUSTER_INDEX (CIN) or a RELATION_INDEX (RIN)
Not displayed Uppercase System maintained Not updatable by user Defined on IND supertype | INDEX_TYPE | |
| NAME | VARCHAR2(30) | N | The name of this index.
Prompt: Name Uppercase Defined on IND supertype | ||
| RELATION_INDEX_FOR | VARCHAR2(3) | N | Arc 48 discriminator. Indicates whether the RELATION_INDEX is for a TABLE_DEFINITION or a SNAPSHOT_DEFINITION
Not displayed Uppercase System maintained Not updatable by user | RELATION_INDEX_FOR | |
| RELATION_INDEX_TYPE | VARCHAR2(20) | N | Indicates whether this index is to be used to maintain uniqueness or is a bitmap index
Prompt: Index Type Uppercase | IND_UNIQUE_INDICATOR | NOT UNIQUE |
| REMARK | VARCHAR2(2000) | Y | A brief comment on why the index is created and how it is used.
Prompt: Comment Defined on IND supertype | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC Defined on IND supertype |
Description |
| NOTES | CDINOT Defined on IND supertype |
Notes |
| Other Properties |
|---|
| RELATION_INDEX has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference RELATION_INDEX:
Note: