KeepExisting Element (DTA)


Applies To: SQL Server 2016

Specifies the physical design structures (indexes, indexed views, or partitioning) that Database Engine Tuning Advisor must retain when generating its recommendation.

...code removed...  

Data type and lengthstring, length limit enforced by the server.
Allowed valuesNONE
No existing structures.

All existing structures.

All partition-aligned structures.

All clustered indexes on tables.

All clustered and nonclustered indexes on tables.

Use only one of these values with this element.
Default valueNone.
OccurrenceOptional. Can use only once for each TuningOptions element.
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