Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | INDEX_STORAGE |
| Short Name | INS |
| View Name | CI_INDEX_STORAGES |
| Description | Storage related to an index in the context of a specific |
| implementation of the object to which it applies. | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | IMPLICIT_INDEX_STORAGE |
| USER_OBJECT_INDEX_STORAGE | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_INS |
| Changes: | Summary of changes to INDEX_STORAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| CLUSTER_REFERENCE | N |
Prompt: Cluster Implementation
Transferable only if null |
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 |
Must be for an index on one and only one SNAPSHOT_IMPLEMENTATION | 76 |
| TABLE_IMPLEMENTATION_REFERENCE | N |
Prompt: Table Implementation
Transferable only if null |
Must be for an index on one and only one TABLE_IMPLEMENTATION | 76 |
| STORAGE_DEFINITION_REFERENCE | Y | Prompt: Storage Definition | May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y | Prompt: Tablespace | 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 | ||
| 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 | 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 | 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 | 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 | ||
| INSTANCES | NUMBER(6, 0) | Y | Specifies how index will be split between instances
Prompt: Instances Range: 0 to 999999 | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of transaction entries for this index
Prompt: Max Trans Range: 1 to 255 | ||
| PARALLEL | VARCHAR2(1) | N | Indicates if parallel querying is to be used
Prompt: Parallel ? Uppercase | 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 | ||
| REVERSE_OR_NOSORT | VARCHAR2(10) | Y | Indicates whether REVERSE or NOSORT options are to be used for this index
Prompt: Reverse or Nosort Uppercase | 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 | Non-Oracle Storage |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference INDEX_STORAGE:
Note: