Export (0) Print
Expand All

Table Element for Schema (DTA)

Specifies the table for tuning.

<Schema>
...code removed here...
    <Table>...</Table>

Attribute

Description

NumberOfRows

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

None.

Occurrence

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

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

ADD
Show:
© 2014 Microsoft