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 |
|
Child elements |
Remarks
If you do not specify a Table element, Database Engine Tuning Advisor will assume all tables on the specified database can be tuned.