Optimizing the Fetch Size – Database Connectivity
Optimizing the Fetch Size To optimize the processing of rows in the result set that resulted from executing a query, only a certain number of these rows are fetched at a time from the database when they are needed by the result set. The default number to fetch, called the default fetch size, is set