4D v16.3
Index Type
- 4D Language Reference
-
- List of constant themes
-
- 4D Environment
- 4D Write Pro
- ASCII Codes
- Backup and Restore
- BLOB
- Colors
- Communications
- Data File Maintenance
- Database Engine
- Database Events
- Database Parameters
- Date Display Formats
- Days and Months
- Design Object Access
- Dictionaries
- Digest Type
- Euro Currencies
- Events (Modifiers)
- Events (What)
- Expressions
- Field and Variable Types
- Find Window
- Font Styles
- Font Type List
- Form Area
- Form Events
- Form Object Types
- Form Objects (Access)
- Form Objects (Properties)
- Form Parameters
- Function Keys
- Graph Parameters
- Hierarchical Lists
- HTTP Client
- Index Type
- Is License Available
- ISO Latin Character Entities
- LDAP
- List Box
- Listbox Footer Calculation
- Log Events
- Math
- Menu Item Properties
- Multistyle Text
- Multistyle Text Attributes
- Open Form Window
- Open Window
- Pasteboard
- PHP
- Picture Compression
- Picture Display Formats
- Picture Metadata Names
- Picture Metadata Values
- Picture Transformation
- Platform Interface
- Platform Properties
- Print Options
- Process State
- Process Type
- QR Area Properties
- QR Borders
- QR Commands
- QR Document Properties
- QR Operators
- QR Output Destination
- QR Report Types
- QR Rows for Properties
- QR Text Properties
- Queries
- Relations
- Resources Properties
- SCREEN DEPTH
- SET RGB COLORS
- Shortcut and Associated Keys
- SQL
- Standard System Signatures
- System Documents
- System Folder
- System Format
- TCP Port Numbers
- Text Values for Associated Standard Action
- Time Display Formats
- Trigger Events
- Value for Associated Standard Action
- Web Area
- Web Server
- Web Services (Client)
- Web Services (Server)
- Windows
- XML
4D v16.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 |
See also
PROPERTIES
Product: 4D
Theme: List of constant themes
HISTORY
ARTICLE USAGE
4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)
© 1985-2018 4D SAS / 4D, Inc. All rights reserved.