Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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).