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.
About this task
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.
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
Maximum
rows to retrieve field.