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.
Procedure
To limit SQL Results view result sets:
- Click
- Expand the Data Management node, the SQL
Development node, and click SQL Results View Options.
- 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.
- Click OK to apply your changes.
Results
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.