IBM DB2 Query Patroller Administration Guide

Profiling

If feasible, profile the set of queries that will access the data warehouse through DB2 Query Patroller by submitting each query in isolation. This method provides valuable statistics, such as the cost estimate of the query, the time for the query to be executed, and the size of the answer set. Additional information, such as the behavior patterns of the end users and hardware resources, helps you determine the appropriate setting for DB2 Query Patroller configuration parameters.


[ Top of Page | Previous Page | Next Page ]