INDEX_ADVISOR_MAX_ROWS Option

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

Allowed Values

Value

Description

0

Minimum value disables collection of index advice

4294967295

Maximum value allowed

Default

0

Scope

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

Description

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;
Related reference
FP_LOOKUP_SIZE Option
INDEX_ADVISOR Option