Adding Custom Indexes
Custom indexes are defined using the Indexes tag. The table below describes the elements in this tag.
|
Attribute
|
Default Value
|
Possible Values
|
Required?
|
Description
|
|---|---|---|---|---|
|
ClassName
|
name attribute
|
Yes
|
Windchill class name of the database table where you want to add an index.
Example: <ClassName name="wt.doc.WTDocumentMaster">
|
|
|
IndexList
|
A list of Index elements
|
Yes
|
List of indexes to be added.
|
|
|
Index
|
Definition for a single index
|
Yes
|
Details for adding an index.
|
|
|
IndexName
|
Name of a DB index in the class specified in ClassName
|
Yes
|
Name of the index to be added.
Example: <IndexName>functionalControlBranch</IndexName>
|
|
|
Unique
|
false
|
true
false
|
No
|
Specify true if no two rows of a table should have duplicate values in the columns.
|
|
ColumnExpression
|
Name of a modeled column or column expression
|
Yes
|
Name of the modeled column or column expression to support function-based index.
Example: <ColumnExpression>masterReference.key.id</ColumnExpression>
If column expression is a function, the column name should be the database column name. Column expression should be specified in the sequence in which you want to create the index.
As SORT, NOSORT options are not supported, by default, the database sorts the indexes in an ascending order when creating the index.
|
 |
Only Oracle database supports custom indexes.
|