Specifies the algorithm used during a delete in a HG index.
DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
Rows deleted
Index size
Width of index data type
Cardinality of index data
Available temporary cache
Machine related I/O and CPU characteristics
Available CPUs and threads
Referential integrity costs
To force a “small” method, set this option to 1. To force the “large” method, set the option to 2. To force a “midsize” method, set the option to 3.