featureset-element-dta.md

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