# 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

```sql
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

```sql
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.

## Related Topics

* [SHOW CROSS\_QUERY\_STATS\_CACHE STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-cross-query-stats-cache-status.md)

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-cross-query-stats-cache/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-cross-query-stats-cache/)

(An index of the documentation is available at /llms.txt)