Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | USER_OBJECT_INDEX_STORAGE |
| Short Name | UIS |
| View Name | CI_USER_OBJECT_INDEX_STORAGES |
| Description | A USER_OBJECT_INDEX_STORAGE defines storage information specific to |
| the implementation of a user defined index in a particular schema. The | |
| index in question may be: | |
| * the definition of an index in the context of a specific | |
| implementation of a table, snapshot or cluster in a schema | |
| * the index used to implement a primary key in the context of a | |
| specific implementation of a table in a schema | |
| * the index used to implement a unique key in the context of a | |
| specific implementation of a table in a schema | |
| In Oracle8 the index may be either a global index or a local index | |
| Sub-type of | INDEX_STORAGE |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_IMPLEMENTATION_REFERENCE SNAPSHOT_REFERENCE CLUSTER_REFERENCE INDEX_REFERENCE PRIMARY_KEY_REFERENCE UNIQUE_KEY_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_INS |
| Changes: | Summary of changes to USER_OBJECT_INDEX_STORAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| INDEX_REFERENCE | N |
Prompt: Index
Transferable only if null |
Must be for the index implementing one and only one INDEX | 75 |
| PRIMARY_KEY_REFERENCE | N |
Prompt: Primary Key
Transferable only if null |
Must be for the index implementing one and only one PRIMARY_KEY_CONSTRAINT | 75 |
| UNIQUE_KEY_REFERENCE | N |
Prompt: Unique Key
Transferable only if null |
Must be for the index implementing one and only one UNIQUE_KEY_CONSTRAINT | 75 |
| CLUSTER_REFERENCE | N |
Prompt: Cluster Implementation
Transferable only if null Defined on INS supertype |
Must be for an index on one and only one CLUSTER_IMPLEMENTATION | 76 |
| SNAPSHOT_REFERENCE | N |
Prompt: Materialized View Implement'n
Transferable only if null Defined on INS supertype |
Must be for an index on one and only one SNAPSHOT_IMPLEMENTATION | 76 |
| TABLE_IMPLEMENTATION_REFERENCE | N |
Prompt: Table Implementation
Transferable only if null Defined on INS supertype |
Must be for an index on one and only one TABLE_IMPLEMENTATION | 76 |
| STORAGE_DEFINITION_REFERENCE | Y |
Prompt: Storage Definition
Defined on INS supertype |
May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y |
Prompt: Tablespace
Defined on INS supertype |
May be for index created in one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DEGREE | NUMBER(6, 0) | Y | Specifies the degree of parallelism. (Property called MAX_SCANS prior to release 2.0)
Prompt: Degree Range: 0 to 999999 Defined on INS supertype | ||
| INDEX_STORAGE_IMPLEMENTING | VARCHAR2(3) | N | Arc 75 discriminator. Indicates whether this relates to an INDEX definition, or an index implementing a PRIMARY_KEY or a UNIQUE_KEY
Not displayed Uppercase System maintained Not updatable by user | INDEX_STORAGE_IMPLEMENTING | |
| INDEX_STORAGE_ON | VARCHAR2(3) | N | Arc 76 discriminator. Indicates whether the INDEX_STORAGE is for an index on a TABLE_, SNAPSHOT_ or CLUSTER_IMPLEMENTATION
Not displayed Uppercase System maintained Not updatable by user Defined on INS supertype | INDEX_STORAGE_ON | |
| INDEX_STORAGE_SUBTYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the INDEX_STORAGE is a USER_OBJECT_INDEX_STORAGE (UIS) or an IMPLICIT_INDEX_STORAGE (IIS)
Not displayed Uppercase System maintained Not updatable by user Defined on INS supertype | INDEX_STORAGE_SUBTYPE | |
| INDEX_STORAGE_TYPE | VARCHAR2(6) | N | Indicates whether for a local or global index. An Oracle7 index is equivalent to an Oracle8 global index
Prompt: Index Type Uppercase Defined on INS supertype | INDEX_STORAGE_TYPE | GLOBAL |
| INITIAL_TRANSACTION | NUMBER(3, 0) | Y | Initial number of transaction entries for this index
Prompt: Init Trans Range: 1 to 255 Defined on INS supertype | ||
| INSTANCES | NUMBER(6, 0) | Y | Specifies how index will be split between instances
Prompt: Instances Range: 0 to 999999 Defined on INS supertype | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of transaction entries for this index
Prompt: Max Trans Range: 1 to 255 Defined on INS supertype | ||
| PARALLEL | VARCHAR2(1) | N | Indicates if parallel querying is to be used
Prompt: Parallel ? Uppercase Defined on INS supertype | YESNO | N |
| PERCENT_FREE | NUMBER(3, 0) | Y | A percentage of free space to allow for the growth of this index
Prompt: Percent Free Range: 0 to 999 Defined on INS supertype | ||
| REVERSE_OR_NOSORT | VARCHAR2(10) | Y | Indicates whether REVERSE or NOSORT options are to be used for this index
Prompt: Reverse or Nosort Uppercase Defined on INS supertype | REVERSE_OR_NOSORT | |
| 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 |
| NON_ORACLE_DATABASE_STORAGE | STODSC Defined on INS supertype |
Non-Oracle Storage |
| Other Properties |
|---|
| USER_OBJECT_INDEX_STORAGE 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 USER_OBJECT_INDEX_STORAGE:
Note: