To enhance performance when you frequently have many identical queries (low write/high read scenarios), you can use the query cache in Exasol. The query cache stores a SELECT query together with its result if certain conditions are fulfilled. If the same query is sent again, the database can read the result directly out of the cache instead of executing the query.

To prevent that stale data is returned, cached queries/results are flushed if the corresponding table objects are changed.