FeatureSet Element (DTA)


Applies To: SQL Server 2016

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

...code removed...  

Data type and lengthstring, no maximum length.
Allowed valuesIDX_IV
Indexes and indexed views.

Indexes only.

Indexed views only.

Nonclustered indexes only.

Use one of these values with this element.
Default valueIDX
OccurrenceRequired once for each TuningOptions element, unless the DropOnlyMode element is used. If DropOnlyMode is used, you cannot use FeatureSet. These elements are mutually exclusive.
Parent elementTuningOptions Element (DTA)
Child elementsNone.

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

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions