2.8.5.1 Running Unload Advisor

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”.

Use the exclude_list option to define a list of schemas and tables to exclude from Unload Advisor.

Use the last_queried_hours option to only recommend unloading tables that were not queried during this past number of hours. The default is 24 hours.

Set memory_gain_ascending to true to rank the unload table suggestions in ascending order based on the table size. The default is false.

Use the limit_tables option to limit the number of unload table suggestions, based on the order imposed by memory_gain_ascending. The default is 10.