CONVERT_HG_TO_1242 option

Function

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

Allowed values

ON, OFF

Scope

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

Default

OFF

Description

Improves read performance of queries against HG indexes.

You 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.