| title | FeatureSet Element (DTA) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | tools-other | |
| ms.topic | conceptual | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | f2070c53-4a5c-4c11-ac38-96ee200c84f0 | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg |
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>
| 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).