featureset-element-dta.md

title	FeatureSet Element (DTA)
description	In the dta utility, the FeatureSet element contains the physical design structures Database Engine Tuning Advisor uses during analysis.
author	rwestMSFT
ms.author	randolphwest
ms.date	03/01/2017
ms.service	sql
ms.subservice	tools-other
ms.topic	reference
ms.collection	data-tools
helpviewer_keywords	FeatureSet element
dev_langs	XML

FeatureSet Element (DTA)

[!INCLUDE SQL Server]

Contains the physical design structures (indexes or indexed views) that you would like Database Engine Tuning Advisor to use during analysis.

Syntax

  
<DTAInput>  
...code removed...  
    <TuningOptions>  
      <FeatureSet>...</FeatureSet>  

Element Characteristics

Characteristic	Description
Data type and length	string, no maximum length.
Allowed values	IDX_IV Indexes and indexed views. IDX Indexes only. IV Indexed views only. NCL_IDX Nonclustered indexes only. Use one of these values with this element.
Default value	IDX
Occurrence	Required once for each TuningOptions element, unless the DropOnlyMode element is used. If DropOnlyMode is used, you cannot use FeatureSet. These elements are mutually exclusive.

Element Relationships

Relationship	Elements
Parent element	TuningOptions Element (DTA)
Child elements	None.

Example

For a usage example of this element, see the Simple XML Input File Sample (DTA).

See Also

XML Input File Reference (Database Engine Tuning Advisor)