Sets the maximum number of rows that can be returned per SQL query issued on behalf of an Analytic Services query.
HAMAXQUERYROWS [appname [dbname]] n
appname | Optional parameter. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the Analytic Server. |
dbname | Optional parameter. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the Analytic Server. |
n | The value of n determines the maximum number of rows retrieved per SQL query. The default is zero, meaning that no row limit is applied. |
This setting determines the maximum number of rows retrieved per SQL query issued on behalf of an Analytic Services query. HAMAXQUERYROWS is a specific limit to an Analytic Services query. The setting provides a way of controlling queries that retrieve too much data.
In the following example, Analytic Services processes up to 100,000 rows per SQL query.
HAMAXQUERYROWS 100000
HAMAXNUMSQLQUERY
HARETRIEVENUMROW
QRYGOVEXECBLK
QRYGOVEXECTIME
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |