INDEX_ADVISOR_MAX_ROWS option

Sets the maximum number of unique advice messages stored to max_rows.

0

Can be set temporary (for the current connection), or persistent for a user/group (such as PUBLIC or DBA). Takes effect immediately.

The INDEX_ADVISOR_MAX_ROWS option is used to limit the number of messages stored by the index advisor. Once the specified limit has been reached, the INDEX_ADVISOR will not store new advice. It will, however, continue to update counts and timestamps for existing advice messages.

SET OPTION public.Index_Advisor_Max_Rows = max_rows;