Table Element for Schema (DTA)


Applies To: SQL Server 2016

Specifies the table for tuning.

...code removed here...  

NumberOfRowsOptional. Integer that allows you to simulate tables of different sizes.
Data type and lengthstring, between 1 and 255 characters.
Default valueNone.
OccurrenceOptional. List as many tables as appropriate for your workload.
Parent elementSchema Element for Database (DTA)
Child elementsName Element for Table (DTA)

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

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

XML Input File Reference (Database Engine Tuning Advisor)

Community Additions