Query Result Caching
When a query is executed, the result is cached for a period. At the end of the period, the result is purged from the system. This feature can substantially reduce query time because Vector 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. For more information, see Query Result Caching in the System Administrator Guide.
Last modified date: 06/28/2024