Skip to main content

%ExtentMgr.Catalog.Index

SQL Table Name: %ExtentMgr_Catalog.Index

Property Inventory

Properties

relationship Extent as %ExtentMgr.Catalog.Extent [ Required , Inverse = Indices , Cardinality = parent ];
Property methods: ExtentGet(), ExtentGetObject(), ExtentGetObjectId(), ExtentGetStored(), ExtentGetSwizzled(), ExtentIsValid(), ExtentNewObject(), ExtentOnDelete(), ExtentRClose(), ExtentRExec(), ExtentRFetch(), ExtentRelate(), ExtentSQLCompute(), ExtentSet(), ExtentSetObject(), ExtentSetObjectId(), ExtentUnRelate(), ExtentUnSwizzle()
property Key as %String);
Key is the index key - the definition of the index properties and collations is any are specified. If no collation is specified for a key component then the collation is based on the component definiton.
Property methods: KeyDisplayToLogical(), KeyGet(), KeyGetStored(), KeyIsValid(), KeyLogicalToDisplay(), KeyLogicalToOdbc(), KeyNormalize(), KeySet()
property Name as %String (COLLATION = "EXACT", MAXLEN = 255, TRUNCATE = 1) [ Required ];
Property methods: NameDisplayToLogical(), NameGet(), NameGetStored(), NameIsValid(), NameLogicalToDisplay(), NameLogicalToOdbc(), NameNormalize(), NameSet()
property Status as %Integer;
Status indicates the current status of the index structure and whether it needs to be built
Property methods: StatusDisplayToLogical(), StatusGet(), StatusGetStored(), StatusIsValid(), StatusLogicalToDisplay(), StatusNormalize(), StatusSet()
property Structure as %String;
Structure is STANDARD, BITMAP or BITSLICE
Property methods: StructureDisplayToLogical(), StructureGet(), StructureGetStored(), StructureIsValid(), StructureLogicalToDisplay(), StructureLogicalToOdbc(), StructureNormalize(), StructureSet()
property Type as %String;
The index type is either IDKEY, PKEY, UNIQUE, EXTENT, STANDARD
Property methods: TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

Indexes

index (IDK on Name) [IdKey, Type = key];
Index methods: IDKCheck(), IDKDelete(), IDKExists(), IDKOpen(), IDKSQLCheckUnique(), IDKSQLExists(), IDKSQLFindPKeyByConstraint(), IDKSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%ExtentMgr.Catalog.Index)

{%%PARENT}($$$cCLASSindex)(ID)
=
Type
Structure
Status
Key
FeedbackOpens in a new tab