Sets the maximum number of unique advice messages stored by the index advisor to max_rows.
Value |
Description |
|---|---|
0 |
Minimum value disables collection of index advice |
4294967295 |
Maximum value allowed |
Can be set temporary (for the current connection), or persistent for a user/group (such as PUBLIC or DBA). Takes effect immediately.
INDEX_ADVISOR_MAX_ROWS limits 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;