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:
- Open the SQL Results View Options page
in the Preferences dialog box by clicking .
- In the Max rows count field, specify
the maximum number of retrieved rows 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.
Results
Whenever you run an SQL statement, the maximum number of rows
that are retrieved is no greater than the amount that you specified
in the
Max rows count field.