on 05-04-2017 3:58 PM
For ASE 16, I don't have this config option set, but I can still run update statistics with a explicit "with hashing" clause.
The docs for this just say "enables SAP ASE to gather hash-based statistics"
Hi Ben
Is it a case of syntax you used is valid and therefore allowed to run
but the actual gathering based on hashing is silently ignored ?
It will be interesting if we have inputs from SAP/Sybase
on checks/tests to run before and after the update stats with hashing option to verify that it did what it claimed to do.
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Re: Is it a case of syntax you used is valid and therefore allowed to run but the actual gathering based on hashing is silently ignored ?
No, as discussed above, the "update statistics hashing" config parameter just controls the default behavior (of whether to use hashing for update stats commands). If you explicitly specify a "with hashing" option, it is used.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.