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.

  
<DTAInput>  
...code removed...  
    <TuningOptions>  
      <KeepExisting>...</KeepExisting>  

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

 ALL
All existing structures.

 ALIGNED
All partition-aligned structures.

 CL_IDX
All clustered indexes on tables.

 IDX
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.
RelationshipElements
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

ADD
Show: