Column Element for Index (DTA)

Column Element for Index (DTA)

 

Applies To: SQL Server 2016

Specifies the columns on which the index is created for a user-specified configuration.

  
<Create>  
  <Index>  
    <Name>...</Name>  
    <Column [Type | SortOrder]>  
     ...code removed here...  
     </Column>  

Type: Optional. Specifies the index column type. Use a string data type to specify this attribute with one of the following allowed values:

  • KeyColumn

    Specifies that the column is referenced by an index key. Use the following syntax to set this attribute:

    <Column Type="KeyColumn">  
    
    

    For more information about key columns, see Clustered and Nonclustered Indexes Described.

  • IncludedColumn

    Specifies that the column is an included column (instead of a key column). Use the following syntax to set this attribute:

    <Column Type="IncludedColumn">  
    
    

    For more information about included columns, see Create Indexes with Included Columns.

SortOrder: Optional. Specifies the sorting order of the column. Use a string data type to specify either an "Ascending" or "Descending" sorting order as follows:

<Column SortOrder="Ascending">  

CharacteristicDescription
Data type and lengthNone.
Default valueNone.
OccurrenceCan specify up to 1024 columns for the Index element.
RelationshipElements
Parent elementIndex Element (DTA)
Child elementsName Element for Column (DTA)

For a usage example of this element, see the XML Input File Sample with User-specified Configuration (DTA).

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions

ADD
Show:
© 2016 Microsoft