Table Element for Schema (DTA)

Specifies the table for tuning.

Syntax

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

Element Attributes

Attribute

Description

NumberOfRows

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

Element Characteristics

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.

Element Relationships

Relationship

Elements

Parent element

Schema Element for Database (DTA)

Child elements

Name Element for Table (DTA)

Remarks

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

Example

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