Table Connection Parameters
Given below are the parameters that you can specify for a table in a datagrid after you click the Add Table button.
Configuration
In the Configuration tab, you can specify the table name and define the fields.
A row of a table is associated with a name and a type.
The following table describes the fields in the Configuration tab of the Table shared resource:
Key Definition
In the Key Definition tab, you must set at least one of the defined fields as the key field to make the table definition valid.
The following table describes the field in the Key Definition tab of the Table shared resource:
Index Definition
In the Index Definition tab, you can select the defined fields as indexes to accelerate the filtering of data when processing queries. An index uses memory to locate matching records, which is faster than iterating through every record. This is optional.
The following table describes the fields in the Index Definition tab of the Table shared resource:
Field | Description |
---|---|
Index Name | Specifies the name of an index.
The index name is a string and must start with a letter or an underscore (_). The name can include any combination of letters and numbers. |
Index Field Names | Specifies the field names that are included in the index. You can create a composite index that includes more than one field. |