Skip to content

Latest commit

 

History

History
87 lines (61 loc) · 2.83 KB

column-element-for-index-dta.md

File metadata and controls

87 lines (61 loc) · 2.83 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection helpviewer_keywords dev_langs
Column Element for Index (DTA)
In the dta utility, the Column element for Index specifies the columns on which the index is created for a user-specified configuration.
rwestMSFT
randolphwest
03/09/2017
sql
tools-other
reference
data-tools
Column element
XML

Column Element for Index (DTA)

[!INCLUDE SQL Server]

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

Syntax

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

Element Attributes

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">

Element Characteristics

Characteristic Description
Data type and length None.
Default value None.
Occurrence Can specify up to 1024 columns for the Index element.

Element Relationships

Relationship Elements
Parent element Index Element (DTA)
Child elements Name Element for Column (DTA)

Example

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)