SAS Namespace Types

Index

Overview

Represents an index on a physical structure. It is tied to the columns that make up the index.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 Intelligence Platform: Security Administration Guide.

OwningPhysicalTable

Attributes

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 LockedBy PublicType UsageVersion

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.

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 , 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

Attribute Details

IndexName
     Type: String 64
The name of the index.

IsClustered
     Type: int
This attribute indicates that this index supports clustering.

IsNoMiss
     Type: int
If true, then missing values are not maintained by the index

IsUnique
     Type: int
This attribute indicates whether this index is a unique index or not.

Association Details

Columns
     Cardinality: 0 to *
     Partner: Indexes

The list of columns that are indexed by this index.

Associated Types:
Column ColumnRange

OwningPhysicalTable
     Cardinality: 1 to 1
     Partner: Indexes

The table that is indexed by this object.

Associated Types:
PhysicalTable WorkTable

Top of Page