IBM FileNet P8, Version 5.2.1            

Index tuning: No search conditions (continuable query)

A continuable query might have no WHERE clause. A composite index might improve the performance of such a query.

For example, the following query has no WHERE clause:
Table 1. Example continuable query with no WHERE clause
Content Platform Engine SQL Corresponding database SQL (continuable query)
SELECT Id 
FROM DocClass
SELECT object_id, object_class_id, security_id, creator, ... 
FROM DocVersion 
WHERE object_class_id 
IN (?) 
AND home_id Is Null 
ORDER BY object_id
If the query is a continuable query that returns many rows, create a composite index on object_class_id in this manner:
CREATE INDEX I_OCID_ID 
ON DocVersion (object_class_id, object_id)

If there are subclasses of DocClass, the database SQL includes the following condition: object_class_id IN (?, ?). In this situation, a sort step on object_id is still required, and so an index on object_class_id alone is sufficient.



Last updated: March 2016
p8ppt295.htm

© Copyright IBM Corporation 2016.