EnterWorks - ETT 097 - How to Ensure Composite Indexes are Maintained
Administration, Performance
Composite Indexes are useful when joining on more than one attribute or performing searches with multiple conditions in the same repository. While they can be created using the Composite Indexes repository and RefreshCompositeIndexes SQL stored procedure, the indexes will be dropped every time the snapshot for the repository is rebuilt. This provides a new stored procedure and workflow that makes it easy to rebuild the composite indexes manually as well as automatically.
Prerequisites - ETT 004