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 |
sp_configure "utility statistics hashing", 0, literalwhere:
on – index attributes are gathered using hash-based statistics.
off – the sort-based algorithm from versions earlier than 15.7 ESD #2 is used.
new – hashing is gathered for minor attributed columns that have not had statistics previously gathered.
default – same as off.