Chapter 15 DBMS-Specific Features

XML indexes

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

Creating 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 Scripting Name Description
Primary XMLPrimary Specifies that this is the primary xml index.
Primary index PrimaryXMLIndex Specifies the primary XML index to use in creating a secondary XML index.
Secondary XML index type SecondaryXMLIndexType Specifies the type of the secondary XML index.

 

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