FeatureSet Element (DTA)

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.


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

CharacteristicDescription
Data type and lengthstring, no maximum length.
Allowed valuesIDX_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 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.
RelationshipElements
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

ADD
Show:
© 2016 Microsoft