space
Previous Page | Next Page

SAS Namespace Types

Index


Subclass of PrimaryType


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

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, IsHidden, LockedBy, PublicType, SecTransctxt, 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, 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

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

Previous Page | Next Page | Top of Page