Setting Resource Limit

You can set up resource limits that can be applied for a query.

About this task

You can set the resource limit for a query result by configuring the row Limits for the user group, Large Objects (LOB) retrieval Options, enabling or disabling Cache for result sets, and setting Acceleration type for the analytics accelerator related queries.

You can set the row limit for the result set from the Query menu or by clicking the Query Settings for Result Set toolbar button.

For the Query Settings for Result Set toolbar button to be enabled, following conditions must be satisfied:
  • Connection to the data source is established
  • Query has been run

Procedure

  1. From the Query Settings for Result Set toolbar button, click Set Resource Limit.
  2. In the Limits tab, populate the required information. For more information on Limits, see Specifying Limits resource limits.
  3. In the LOB Options tab, populate the required information. For more information, see Specifying LOB Options resource limits
  4. In the Cache tab, populate the required information. For more information, see Specifying Cache resource limits
  5. In the Acceleration tab, populate the required information. For more information, see Specifying Acceleration resource limits.
    This option is applicable only for analytics Accelerator related queries.