Limiting the number of retrieved rows for SQL statement runs
You can limit the number of rows that are retrieved when you run an SQL statement. Limiting the number of retrieved rows can decrease the amount of time that it takes to run a statement.
Procedure
To limit the number of rows that are retrieved when you run an SQL statement:
- Click .
- In the Preferences window, expand the Data node, and then click Output.
- On the Output page, select the Limit number of rows retrieved check box.
- In the Maximum rows to retrieve field, specify the maximum number of rows to retrieve when an SQL statement is run. The value that you specify in this field also affects the number of rows that are retrieved for other data-related objects such as stored procedures.
- Click OK.