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 External link opens a new window or tab.