Table Element for Schema (DTA)
Applies to: SQL Server
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).
See Also
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir