Array Blocking for SELECT Requests

The Adapters for Oracle and DB2 support array retrieval from result sets produced by executing SELECT queries or stored procedures. This technique substantially reduces network traffic and CPU utilization.

High FETCHSIZE values increase the efficiency of requests involving many rows, at the cost of higher virtual storage requirements. The default value is 20 for Oracle and 100 for DB2. A value higher than 100 is not recommended because the increased efficiency it would provide is generally negligible.

For more information, see Adapter Commands.


Information Builders