IBM FileNet P8, Version 5.2.1            

Property skew resolution

Address the problem of skew by proper design of the application or with the necessary database-specific solutions.

The following table indicates some possible solutions. For more information about proper application design, see Handling a large number of folders, documents, and objects.
Table 1. Property skew solutions
Database Comment
Oracle Skew solutions for include executing explicit histogram stats and sometimes a large sample percentage. For more information, see the section "Oracle solutions for skew" in the topic Handling a large number of folders, documents, and objects.
DB2® For information about queries on columns with skew, see technote Enabled DB2 Index Use with Skewed Data in the FileNet Content Platform Engine.


Last updated: October 2015
p8ppt289.htm

© Copyright IBM Corporation 2015.