The results of subqueries using the IN operator are not cached to disk even if they have large result sets:
SELECT * FROM emp WHERE deptno IN (SELECT deptno FROM dept) - Only the results of EMP table can be cached to disk. The results of the DEPT table are not cached.
Note: ORDER BY is supported on LONGVARBINARY fields and on VARCHAR fields of less than 65535 characters. In earlier releases, ORDER BY was not supported on LONGVARBINARY fields and VARCHAR fields longer than 255 characters.
