KeepExisting Element (DTA)

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


...code removed...  

Element Characteristics

Characteristic Description
Data type and length string, length limit enforced by the server.
Allowed values NONE
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 value None.
Occurrence Optional. Can use only once for each TuningOptions element.

Element Relationships

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

See Also

XML Input File Reference (Database Engine Tuning Advisor)