IBM FileNet P8, Version 5.2.1            

Query concepts

For tuning purposes, we distinguish between different types of queries and different types of query behavior. In particular, whether a query returns many rows or runs as a continuable or non-continuable query can determine the type of tuning.

The SQL that Content Platform Engine runs on behalf of your query is called database SQL. In some cases, understanding how Content Platform Engine translates your SQL into database SQL can be important for tuning.

SQL execution is one of a number of activities that Content Platform Engine performs to run a query. The query run time is the total time for these activities.



Last updated: March 2016
p8ppt310.htm

© Copyright IBM Corporation 2016.