SHOW CACHE HOTSPOT

Description

This statement is used to display the hotspot information of file cache.

Syntax

   SHOW CACHE HOTSPOT '/[compute_group_name/table_name]';

Parameters

1. compute_group_name : Name of compute group.
2. table_name : Name of table.

Example

1. View the table creation statement of a table

   SHOW CACHE HOTSPOT '/';

Related Commands

• WARMUP CACHE

References

• MANAGING FILE CACHE

Keywords

SHOW, CACHE, HOTSPOT