Filegroup Element for Index (DTA)
Applies to: SQL Server
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).