...
OPTIONAL
Keep Connection Open _-- If selected the query results or are retrieved from the data source as needed, otherwise the entire query results are brought over from the data source and cached in memory. It is recommended that you set this option with larger datasets. Never use this option if you are storing the resultset in the session.
Note: Any parameter may be referenced in the query by enclosing the parameter in curly braces.
...