When a query is executed, the result is persisted (that is cached). The result is purged from the system if there is limitation to the memory allocated, or when the result is invalidated due to an update.

This feature can substantially reduce query time because Ingres bypasses query execution and instead retrieves the result directly from the cache. Query result caching will improve performance only when there are multiple requests of the same select query. Typically, query results are reused if certain conditions are met.

The Spill to Disk feature enables configuring query results to spill to disk when the query result memory is low.

See Query Result Caching in the System Administrator Guide.