IBM FileNet P8, Version 5.2.1            

Validating index use in a query

Validating index use is to ensure that the database SQL query executes fast and uses the right indexes.

Important: A query might still run slow for reasons other than slow database SQL execution. For more information, see Query run time.

When indexes are being used, the database query typically runs faster. But a query might run fast on the second execution simply because data is buffered in the database. A best practice is to get both the first and second query execution times. In addition, obtain the query execution plan to see whether the database is using the right indexes and plan.



Last updated: March 2016
p8ppt276.htm

© Copyright IBM Corporation 2016.