Execute SQL Fetch All Rows

The Execute SQL Fetch All Rows option works exactly like the Execute SQL option for all queries except those that return results, such as select queries. For queries that return results, the fetch all rows option makes sure to fetch all rows from the database and display all of those rows in the query editor, as opposed to only fetching a set number of rows and not doing another fetch until the user scrolls down to see unfectched rows.

Care should be used when using the fetch all rows options for queries that are expected to return very large result sets. Very large result sets could consume enough memory and generate enough network traffic to cause performance problems.

To increase performance and reduce the number of network calls, the fetch size preference for the execute sql fetch all option can be increased by changing the value in the preferences. The default value is typically 100.