update statistics hashing

update statistics hashing enables SAP ASE to gather hash-based statistics.

Summary Information

Default value

off

Range of values

One of:
  • off – no hashing
  • on – hashing on all columns
  • partial – hashing only for low unique count columns
  • default – off

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

General Information

The values for update statistics are character data, so you must use 0 as a placeholder for the second parameter, which must be numeric, and specify off, on, partial, or default for the third parameter. For example:
sp_configure "update statistics hashing", 0, partial