FeatureSet Element (DTA)

Applies to: 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>

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.

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

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