Element Details: Create+DB+Index
 Back


Available in: Logi Info Source code name: CreateDbIndex

Used to add an index to a database table.

Element Group:Load Data Elements



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ConnectionID
UserDefined
Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
FieldNames
UserDefined
(Required) A comma seperated list of fields to use in the index. Examples using two fields: CustomerID, CustomerName <-- Creates a standard index based on two fields (both in ascending order). CustomerID, CustomerName DESC <-- CustomerID will be indexed in ascending order and CustomerName descending order.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
IndexName
UserDefined
(Required) Name of the index.
IndexType
UserDefined
Used to define either a regular or unique index.
TableName
UserDefined
(Required) The name of a database table.



PARENT ELEMENTS

Click element to drill down for more information.

Etl Job
If
If ETL Error If File Exists If Folder Exists


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top