Export (0) Print
Expand All

KeepExisting Element (DTA)

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>

Characteristic

Description

Data type and length

string , length limit enforced by the server.

Allowed values

NONE

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 value

None.

Occurrence

Optional. Can use only once for each TuningOptions element.

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

Community Additions

ADD
Show:
© 2014 Microsoft