A correlated subquery contains references to one or more tables outside of the subquery and is re-executed each time the value in the referenced column changes. Sybase IQ allows users to choose caching methods for executing the correlated subquery using the SUBQUERY_CACHING_PREFERENCE option.
