Export (0) Print
Expand All

Table Element for Schema (DTA)

Specifies the table for tuning.

...code removed here...

Attribute Description


Optional. Integer that allows you to simulate tables of different sizes.

Characteristic Description

Data type and length

string, between 1 and 255 characters.

Default value



Optional. List as many tables as appropriate for your workload.

Relationship Elements

Parent element

Schema Element for Database (DTA)

Child elements

Name Element for Table (DTA)

If you do not specify a Table element, Database Engine Tuning Advisor will assume all tables on the specified database can be tuned.

For a usage example, see Server Element (DTA).

Community Additions

© 2014 Microsoft