v.19.3Improvements

Add One Required Argument to SET Index (max Stored Rows Number)

Add one required argument to SET index (max stored rows number). #4386 (Nikita Vasilev)
Added a required argument to the SET index specifying the maximum number of stored rows.

Why it matters

This feature allows users to explicitly limit the number of rows stored in a SET index, improving control over memory usage and performance when using this index type.

How to use it

When creating a SET index, specify the maximum number of stored rows as a required argument, for example:

ALTER TABLE table_name ADD INDEX index_name SET(column_name, max_rows_number) TYPE set();