The SAP ASE server scans samples of data pages. You can use update statistics to create and update statistics on the leading column of all indexes on the specified table, or the leading column of a specified index.
update statistics table_name [index_name] with sampling = N percent
When you use the sampling = N percent option with the using steps value , you must specify the sampling = N percent option last:
update statistics titles (type) using 40 value with sampling = 10 percent
If you do not, you get an error message:
update statistics titles (type) with sampling = 10 percent using 40 value
Msg 156, Level 15, State 2: Line 1: Incorrect syntax near the keyword 'using'.