Skip to Content
Former Member
Dec 17, 2015 at 06:54 AM

Update Statistics - SAP ASE


Dear Colleagues,

One of the scheduled UPDATE STATISTICS job, failed to run.

Hence I was trying to execute it manually.

1> update index statistics 'S30.SAPSR3./BI0/F0SMD_PE2H'

2> go

Msg 102, Level 15, State 181:

Server 'S30', Line 1:

Incorrect syntax near 'statistics'.

My table name is S30.SAPSR3./BI0/F0SMD_PE2H. Though it looked very simple, but i spend a day, with all possible ways to get rid of the syntax error, but all in vain. I wanted to run with sampling option so as to improve the time consumption.

Please give me some helping hand on this. I am running on ASE 15.7 , SP134.