Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.