USE_CACHED_RESULT
Applies to: Databricks SQL
The USE_CACHED_RESULT
configuration parameter controls whether the session caches results sets which meet certain restrictions.
If a query is re-submitted and the underlying tables have not changed, Databricks SQL can re-use the result set, reducing query execution cost.
You can set this parameter at the session level using the SET statement.
The system default for this setting is TRUE
.
> SET use_cached_result = true;
> SELECT count(1) FROM T;
-- Re-use the result from the previous query
> SELECT count(1) FROM T;