Management Tasks#
Management tasks are object-type-specific actions you run against a selected object. For example, a “Customers” view may offer Rebuild persistent cache but not Evict from Spark in-memory cache, depending on its underlying processing engine.
Run a task from the Management Tasks tab on a table or view in the Administration Portal, or in SQL with the matching stored procedure (each takes the object’s three-part name).
Refresh statistics#
Refreshes all statistics for the selected object, respecting its statistics configuration.
EXEC qua_analyze_table 'MyVdb.dbo.MyView';
See qua_analyze_table.
Evict from Spark in-memory cache#
Orders the Apache Spark instance to remove the in-memory cache of the selected object.
EXEC qua_evict_spark_inmem_cached_table 'MyVdb.dbo.MyView';
Rebuild persistent cache#
Rebuilds the persistent cache of a view according to its configured materialization strategy (for example Rotating tables or Single table).
EXEC qua_refresh_persistent_cache 'MyVdb.dbo.MyView';
Refresh row count statistics#
Refreshes only the selected object’s row-count statistics.
EXEC qua_update_row_count_object_statistics 'MyVdb.dbo.MyView';