CONVERT_HG_TO_1242 option

Function

Converts pre-version 12.4.2 HG (High_Group) indexes to an improved format.

Allowed values

ON, OFF

Default

OFF

Scope

Can be set only for the PUBLIC group. Takes effect when you run sp_iqcheckdb in any mode.

Description

Improves read performance of queries against HG indexes.

Set this option and then run sp_iqcheckdb only once, and only for columns with HG indexes that were created before version 12.4.2.