OnlineIndexOperation Element (DTA)
Specifies whether the indexes, indexed views, or partitions that Database Engine Tuning Advisor recommends can be created online.
Syntax
<DTAInput>
...code removed...
<TuningOptions>
<OnlineIndexOperation>...</OnlineIndexOperation>
Element Characteristics
Characteristic | Description |
---|---|
Data type and length |
string, no maximum length. |
Allowed values |
Use one of these values with this element. If indexes are created online, the keyword ONLINE = ON is appended to its object definition. |
Default value |
None. |
Occurrence |
Optional. If used, can only be used once for the TuningOptions element. |
Element Relationships
Relationship | Elements |
---|---|
Parent element |
|
Child elements |
None. |
Example
For a usage example of this element, see the Simple XML Input File Sample (DTA).
See Also
Reference
XML Input File Reference (DTA)