Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

Legacy Code Example

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

Community Additions

ADD
Show:
© 2015 Microsoft