4D v14.3

Index Type

Home

 
4D v14.3
Index Type

Index Type 

 

Constant  Type Value Comment
Cluster BTree index  Longint 3 B-Tree type index using clusters. This type of index is optimized when the index contains few keywords, i.e. when the same values occur frequently in the data.
Default index type  Longint 0 4D specifies the index type (excluding keywords indexes) that is the most optimized according to the contents of the field.
Keywords index  Longint -1 Permits word-by-word indexing of field contents. This type of index can only be used with fields of the Text, Alpha or Picture type. Warning: Keywords indexes cannot be composite.
Standard BTree index  Longint 1 Standard B-Tree type index. This multi-purpose index type is used in previous versions of 4D
 
PROPERTIES 

Product: 4D
Theme: List of constant themes

 
SEE ALSO 

CREATE INDEX
SET INDEX

 
ARTICLE USAGE

4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)

Inherited from : Index Type ( 4D v12.4)