Options dialog: Query Governor tab

Use this tab to specify how Discoverer uses summaries and performs queries.

Note: Do not change these options unless advised to do so by the Discoverer manager.

For more information, see:

"What are summaries?"

"What are worksheets, workbooks, and queries?"

Summary Data

When do you want to use Summary data?

Use this drop down list to specify when you want Discoverer to use summaries. The table below describes options available.

Option	Use to
Always, when available	Specify that you want Discoverer to use summaries automatically where possible.
Only when summary data is not out of date (stale)	Specify that you want Discoverer to use summaries when up-to-date data is available.
Never	Specify that you do not want Discoverer to use summaries.

Query Governor

Use these radio buttons to specify how Discoverer handles queries.

• Warn me if predicted time exceeds

  Use this check box to display a warning when the predicted query times exceed the time that you define in the box on the right. The estimated query time is displayed so that you can choose whether to continue. If the wait time is too long, you can schedule the workbook to run at a later time. For example, you might want to schedule the workbook to run overnight so that it is ready to open in the morning.

• Prevent queries from running greater than

  Use this check box if you do not want to run queries when the predicted query time exceeds the time that you define in the box on the right.

• Limit retrieved query data to

  Use this check box to not retrieve more than the number of rows that you define in the box on the right.

• Retrieve data incrementally in groups of

  Use this field to define how many rows to retrieve from the database at once.

• Cancel list of values retrieval after

  Use this field to define the maximum time you want to wait while Discoverer retrieves list of values items.

Notes

• If you change the Query Governor settings on this tab, note the following:
  • If you set the number of Rows per screen page value (on the Sheet Format tab) to be greater than the Retrieve data incrementally in groups of value, Discoverer completes enough fetches from the database to fill the page.

  • These settings also depend on the Limit retrieved query data to value being high enough to satisfy the number of Rows per screen page setting.

  • If the Retrieve data incrementally in groups of value is greater than or equal to the Limit retrieved query data to value, only one retrieval increment is fetched from the database.