IBM FileNet P8, Version 5.2.1            

Property skew

When most but not all rows in the table have the same value for a property, the column values are skewed. Property skew might cause a query not to use a database index.

Because of skew for Property1, for example, a query execution plan might not use the database index on that property in the following query:
SELECT Id 
FROM Document 
WHERE Property1 = 'value'
Whether the index is used depends on the following circumstances:


Last updated: March 2016
p8ppt304.htm

© Copyright IBM Corporation 2016.