Chapter 12 DBMS-Specific Features

XML indexes

PowerDesigner models XML indexes as table indexes with an index type set to "XML".

Creating an XML index

Steps To create an XML index:

  1. Create an index by opening the property sheet of a table, clicking the Indexes tab and clicking the Add a Row tool.
  2. Open the property sheet of the new index by clicking the properties tool, and then select XML from the list of Types on the General tab.
  3. Click the Microsoft tab and specify any additional options.
  4. Click OK to confirm your changes and close the property sheet.

XML index properties

You can modify an object's properties from its property sheet. To open an XML index property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name Description
Primary Specifies that this is the primary xml index.

Scripting name: XMLPrimary
Primary index Specifies the primary XML index to use in creating a secondary XML index.

Scripting name: PrimaryXMLIndex
Secondary XML index type Specifies the type of the secondary XML index.

Scripting name: SecondaryXMLIndexType
Fill factor Specifies a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild.

Scripting name: FillFactor
Max degree of parallelism Overrides the max degree of parallelism configuration option for the duration of the index operation. Use MAXDOP to limit the number of processors used in a parallel plan execution. The maximum is 64 processors.

Scripting name: MaxDop
Pad index Specifies index padding.

Scripting name: PadIndex
Statistics no recompute Specifies whether distribution statistics are recomputed.

Scripting name: StatisticsNoRecompute
Drop existing Specifies that the named, preexisting clustered, nonclustered, or XML index is dropped and rebuilt.

Scripting name: DropExisting
Sort in temporary database Specifies whether to store temporary sort results in tempdb.

Scripting name: SortInTempDB
Allow row locks Specifies whether row locks are allowed.

Scripting name: AllowRowLocks
Allow page locks Specifies whether page locks are allowed.

Scripting name: AllowPageLocks

 

Copyright (C) 2008. Sybase Inc. All rights reserved.