Limiting SQL Results view result sets

You can set preferences to modify the amount of information that is displayed in the SQL Results view after a database action completes. This helps to improve performance when you are working with large databases.

To limit SQL Results view result sets:

  1. Click Window > Preferences.
  2. Expand the Data Management node, the SQL Development node, and click SQL Results View Options.
  3. Modify the number of rows returned in the result set, or the number of rows to display in the results view. You can also set additional preferences such as whether to display column headings or row numbers.
  4. Click OK to apply your changes.
The next time you perform a database action, the result set that is displayed in the SQL Results view is limited by the options that you set.

Feedback