.show database cache query_results command
Returns a table showing statistics related to the query results cache made against the context database.
Permissions
You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.
Syntax
.show database cache query_results
Learn more about syntax conventions.
Returns
| Output parameter | Type | Description |
|---|---|---|
| NodeId | string |
Identifier of the cluster node. |
| Hits | long |
The number of cache hits. |
| Misses | long |
The number of cache misses. |
| CacheCapacityInBytes | long |
The cache capacity in bytes. |
| UsedBytes | long |
The cache used space. |
| Count | long |
The number of unique query results stored in the cache. |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for