Result caching ?

Hello,

I wonder if Oracle does something like result caching : for example, if i execute a query with some computation (SELECT ... FROM ... ORDER BY MyFunction(..)) and a few time latter, i redo the same query. Does Oracle compute again the second time or does it keep in a cache the result of the first one ?

Have any idea ? :)

Emmanuel Received on Fri Jul 23 1999 - 11:11:55 CDT