Enables the prefetch feature. When enabled, the JDBC Client requests a next set of rows from the server while the client application is processing the previous set of rows.
This property can be specified using:
• JDBC data source
• URL
• java.util.properties
• server data source
Valid Values
0 | 1
When set to 1, the prefetch feature is enabled. Overall throughput increases, if the application always fetches all rows from a result set. When this feature is enabled and the application does not fetch all data from result sets, performance can be significantly degraded.
