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:

  1. Open the SQL Results View Options page in the Preferences dialog box by clicking Windows > Preferences > Data Management > SQL Development > SQL Results View Options.
  2. 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.
  3. 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.

Feedback