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 15.0 allows users to choose caching methods for executing the correlated subquery.
See “SUBQUERY_CACHING_PREFERENCE option” in Chapter 2, “Database Options,” in Reference: Statements and Options.
