Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

DROP ... FROM CROSS_QUERY_STATS_CACHE

The DROP ... FROM CROSS_QUERY_STATS_CACHE command provides commands to remove entries from the cross query stats cache on the connected aggregator, either clearing all entries or only those associated with sampling.

DROP ALL FROM CROSS_QUERY_STATS_CACHE

Clears all entries from the cross query stats cache on the connected aggregator.

Syntax

DROP ALL FROM cross_query_stats_cache;

Remarks

  • Use this command when you want to reset the cache completely, for example after major schema changes or tuning experiments.

DROP SAMPLE FROM CROSS_QUERY_STATS_CACHE

Clears only cache entries that are associated with sampling queries.

Syntax

DROP SAMPLE FROM cross_query_stats_cache;

Remarks

  • Use this command when you want to invalidate cached sampling results but keep other feedback rowcount entries.

Last modified:

Was this article helpful?