> ## Documentation Index
> Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Fetch Size

<a id="fetch-size" />

The Simba Amazon Athena JDBC Connector supports a maximum fetch size of 1000 rows. This is consistent with the maximum fetch size that is supported by the Athena service when the result set streaming API is not used (`UseResultsetStreaming=0`).

If you use the `setFetchSize()` method from the `Statement` class to set a fetch size greater than 1000 without using the result set streaming API, the Simba Amazon Athena JDBC Connector limits the value to 1000. When the result set streaming API is used, the connector does not impose a maximum limit on the fetch size.

If the `setFetchSize()` method is not called on the Statement object, the default fetch size is 0. In this case the fetch size is set using the `RowsToFetchPerBlock` configuration option. For more information see [RowsToFetchPerBlock](/simba/athena/athena_jdbc_install_guide/connector_configuration_options/rowstofetchperblock).

<Note>
  **Note:** While setting a large fetch size value when using the result set streaming API can give you better fetch performance, it can also result in higher memory usage. This can be mitigated if the JDBC application can retrieve the result set from the connector quickly.
</Note>