result_cache [Oracle SQL hint]

select /*+ result_cache */ ....

result_cache is a hint that is new with Oracle 11g. It caches the result set of the select statement. If now another session does the same select statement, Oracle can return the result from the cache rather than executing the query, which might be a performance improvement.

		result_cache [Oracle SQL hint]
		select /+ result_cache* */ .... result_cache is a hint that is new with Oracle 11g. It caches the result set of the select statement. If now another session does the same select statement, Oracle can return the result from the cache rather than executing the query, which might be a performance improvement. See also other hints.


	René Nyffenegger's collection of things on the web
	René Nyffenegger on Oracle - Most wanted - Feedback - Follow @renenyffenegger