utility statistics hashing

utility statistics hashing enables the gathering of index attributes using hash-based statistics when creating an index.

Summary information

Default value

off

Range of values

0 (followed by parameter option)

Status

Dynamic

Display level

Intermediate

Required role

When granular permissions is enabled, manage server configuration is required. When granular permissions is disabled, sa_role is required.

Configuration groups

Lock Manager
Enable hashing with:
sp_configure "utility statistics hashing", 0, literal
where: