Use Query Statistics dialog

Use this dialog to specify how you collect query statistics for estimating best summaries. For example, to use query statistics where queries exceed a specified amount of CPU time.

This dialog is also known as:

Summary Wizard: Step 3

For more information, see:

"Creating summary folders manually"

"Managing summary folders"

Specify search criteria to obtain statistics on query performance, then click "Search"

Use these settings to Select a query to be summarized from the list below.

Show query statistics from within the last _

Use this field to define how recent the query statistic must be to qualify for the query list.

Average CPU Time exceeds _

Use this field to specify the minimum time required to execute the query on the database server.

Average elapsed time exceeds _

Use this field to specify the minimum time required to execute the query on the client workstation.

Number of queries exceeds _

Use this field to specify the minimum number of runs executed for the selected query. The runs may have been executed by different users at different times, but all used the same combination of folders and items.

Search

Use this button to search for query statistics matching the search criteria specified above and display them in the Select a query to be summarized list.

Select a query to be summarized

This list displays query statistics matching the search criteria specified.

Select a query from the list to display the query's folders, joins and items in the lower right panel of the dialog, and activate the Next button.

The #Hits column records the number of times a query has been run by end users.

Notes

• Summaries built using Query statistics are refreshed by Discoverer. These are referred to as managed summary folders.

• A check mark or cube icon indicates that the current query has found a matching summary folder from a previous query. The symbol indicates an exact match that includes all objects.