featureset-element-dta.md

title	FeatureSet Element (DTA)
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	tools-other
ms.topic	conceptual
dev_langs	XML
helpviewer_keywords	FeatureSet element
ms.assetid	f2070c53-4a5c-4c11-ac38-96ee200c84f0
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer
ms.custom	seo-lt-2019
ms.date	03/01/2017

FeatureSet Element (DTA)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)