Filegroup Element for Index (DTA)
Specifies the filegroup on which the index is to be created for a user-specified configuration.
Syntax
<Index>
<Name>...</Name>
<Column>
<Name>...</Name>
<Filegroup>...</Filegroup>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | string, unlimited length. |
| Default value | None. |
| Occurrence | Optional. Can use once for each Index element. This element cannot be used if the PartitionScheme and PartitionColumn elements are specified for the Index element. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent element | Index Element (DTA) |
| Child elements | None. |
Example
For a usage example of this element, see XML Input File Sample with User-specified Configuration (DTA).