Table Element for Schema (DTA)

 

Applies To: SQL Server 2016

Specifies the table for tuning.

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

AttributeDescription
NumberOfRowsOptional. Integer that allows you to simulate tables of different sizes.
CharacteristicDescription
Data type and lengthstring, between 1 and 255 characters.
Default valueNone.
OccurrenceOptional. List as many tables as appropriate for your workload.
RelationshipElements
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

ADD
Show: