Element Type Definition: INDEX

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	INDEX
Short Name	IND
View Name	CI_INDEXES
Description	Definition of an index

Sub-type of	SECONDARY_ACCESS_ELEMENT
Non-instantiable super-type of	CLUSTER_INDEX
	RELATION_INDEX

	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_IND
Changes:	Summary of changes to INDEX in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

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	YESNO	Y
COMPUTE_STATISTICS_FLAG	VARCHAR2(1)	N	Indicates whether statistics are to be collected on creation of index Prompt: Compute Statistics ? Uppercase	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	INDEX_TYPE
NAME	VARCHAR2(30)	N	The name of this index. Prompt: Name Uppercase
REMARK	VARCHAR2(2000)	Y	A brief comment on why the index is created and how it is used. Prompt: Comment
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	Description
NOTES	CDINOT	Notes

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference INDEX:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each USER_OBJECT_INDEX_STORAGE must be for the index implementing one and only one INDEX (in arc)

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype