If your application does not need scrollable dynaset, then you can create
forward only dynaset with ORADYN_NOCACHE (H8) option. With this option, performance
improvement can be gained by eliminating the overhead of creating local cache
file and the overhead of reading/ writing data from that file.
If the application does not make any update to the dynaset, then you can
create read-only dynaset with ORADYN_READONLY (H4) option. With this option,
performance improvement can be gained by eliminating the overhead of local parsing of
SQL statement and reducing network trips for SQL statement execution.