When you frequently have many identical queries, such as in low write/high read scenarios, you can use the query cache feature in Exasol to enhance performance . 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 from 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.