IBM FileNet P8, Version 5.2.1            

SQL tuning: Non-continuable query

For a non-continuable query, you can change the query in two main ways to improve search performance: by adding more restrictive search conditions for the properties that are indexed and by limiting the number of rows that are returned.

To limit the number of returned rows, add the TOP N keyword to the query. (In an application, you might indirectly add this keyword when you specify the maximum number of returned rows in the application interface.) For example, the following query returns a maximum of 200 rows:
SELECT TOP 200 Id
FROM Document
WHERE Property1 = 'value' 
Important: The user might not have access to some rows because of security permissions; these non-accessible rows are automatically removed from the returned results. Because security permissions have to be checked on each row, many rows might need to be retrieved to find rows that are accessible. For this reason, do not rely on security permissions to limit the number of rows that a query returns.
Remember: While the initial SQL execution of the database query might be fast, the overall user search might still be slow because of other query activities. For more information, see Query run time.


Last updated: March 2016
p8ppt270.htm

© Copyright IBM Corporation 2016.