Export (0) Print
Expand All

Partitioning Element (DTA)

Contains the partitioning scheme that you would like Database Engine Tuning Advisor to use during analysis.

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

Characteristic

Description

Data type and length

string , no maximum length.

Allowed values

NONE

No partitioning.

FULL

Full partitioning. (Enhances performance.)

ALIGNED

Aligned partitioning only. (Enhances manageability.)

Use only one of these values with this element.

ALIGNED means that in the recommendation generated by Database Engine Tuning Advisor every proposed index is partitioned in exactly the same way as the underlying table for which the index is defined. Nonclustered indexes on an indexed view are aligned with the indexed view.

Default value

NONE

Occurrence

Required once for the TuningOptions element, unless the DropOnlyMode element is used. If DropOnlyMode is used, you cannot use Partitioning. These elements are mutually exclusive.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft