Dremio 15.0.0 improves query performance by providing an in-memory cache for the query planner. Dremio stores query plans in the cache so that it doesn’t need to reproduce the query plan the next time it encounters that query. The feature is diabled by default. To enable the feature, set the
planner.query_plan_cache.enabled support key to
true. See Support Keys for instructions on setting support keys.
By default, the cache stores 1000 query plans. Dremio administrators may customize the maximum by setting the
planner.plan_cache_max_entries support key to the desired value.
By default, the cache expires after 10,000 minutes. Dremio administrators may customize the expirations by setting the
planner.plan_cache_expiration_minutes support key to the desired value.
By default, the cache may use ??? MB of memory. Dremio administrators may customize this limit by setting the
planner.plan_cache_memory_limits support key to the desired value.
The query planner cache does not support Apache Iceberg and Hive tables.