SAS Namespace Types |
Subclass of PrimaryType
Represents an index on a physical structure. It is tied to the columns that make up the index.
The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.
Name | Description | Type | Length |
IndexName | The name of the index. | String | 64 |
IsClustered | This attribute indicates that this index supports clustering. | int | |
IsNoMiss | If true, then missing values are not maintained by the index | int | |
IsUnique | This attribute indicates whether this index is a unique index or not. | int |
Inherited Attributes
Name,
Id,
Desc,
MetadataCreated,
MetadataUpdated,
ChangeState,
IsHidden,
LockedBy,
PublicType,
UsageVersion
Name | Cardinality | Description | Associated Types |
Columns Partner: Indexes | 0 to * | The list of columns that are indexed by this index. |
Column ColumnRange |
OwningPhysicalTable Partner: Indexes | 1 to 1 | The table that is indexed by this object. | PhysicalTable WorkTable |
Inherited Associations
AccessControls/Objects,
Changes/Objects,
CustomAssociations/OwningObject,
Documents/Objects,
Extensions/OwningObject,
ExternalIdentities/OwningObject,
FavoritesContainers/Favorites,
Groups/Members,
Implementors/ImplementedObjects,
Keywords/Objects,
LocalizedAttributes/AssociatedLocalizedObject,
Notes/Objects,
PrimaryPropertyGroup/AssociatedObject,
Prompts/PromptEnabledObject,
Properties/AssociatedObject,
PropertySets/OwningObject,
ReferencedObjects/AssociatedObjects,
ResponsibleParties/Objects,
SourceTransformations/TransformationSources,
SpecSourceTransformations/SourceSpecifications,
SpecTargetTransformations/TargetSpecifications,
TargetTransformations/TransformationTargets,
Timestamps/Objects,
Trees/Members,
TSObjectNamespace/TSObjects,
UsedByPrototypes/UsingPrototype,
UsingPrototype/UsedByPrototypes,
Variables/AssociatedObject
IndexName
Type: String 64The name of the index.
IsClustered
Type: intThis attribute indicates that this index supports clustering.
IsNoMiss
Type: intIf true, then missing values are not maintained by the index
IsUnique
Type: intThis attribute indicates whether this index is a unique index or not.
Columns
Cardinality: 0 to *
Partner: Indexes
The list of columns that are indexed by this index.
Associated Types:
Column, ColumnRangeOwningPhysicalTable
Cardinality: 1 to 1
Partner: Indexes
The table that is indexed by this object.
Associated Types:
PhysicalTable, WorkTable
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.