For Advisor to recommend tables to unload, the tables must be loaded in HeatWave and a query history must be available.
To enable Unload Advisor, specify the
auto_unload option in
recommend mode. See
Section 2.8.1, “Advisor Syntax”.
exclude_list option to define a
list of schemas and tables to exclude from Unload Advisor.
last_queried_hours option to only
recommend unloading tables that were not queried during this
past number of hours. The default is
TRUE to rank the unload table suggestions
in ascending order based on the table size. The default is
limit_tables option to limit the
number of unload table suggestions, based on the order