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