Skip to content

Latest commit

 

History

History
63 lines (46 loc) · 1.84 KB

table-element-for-schema-dta.md

File metadata and controls

63 lines (46 loc) · 1.84 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection helpviewer_keywords dev_langs
Table Element for Schema (DTA)
In the dta utility, the Table element for Schema specifies the table for tuning. This article describes that element.
rwestMSFT
randolphwest
03/01/2017
sql
tools-other
reference
data-tools
Table element [DTA]
XML

Table Element for Schema (DTA)

[!INCLUDE 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

XML Input File Reference (Database Engine Tuning Advisor)