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>
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).