2218767 - Tempdb becomes full when 'update index statistics' is running on a large table - SAP ASE

• The tempdb database becomes full when an 'update index statistics' command is running on a large table.
   
• The table contains the following indexes: 

1> sp_helpindex mytable
2> go
Object has the following indexes
 
index_name index_keys index_description index_max_rows_per_page index_fillfactor index_reservepagegap index_created index_local
------------------------- ------------------------------------------------------- ----------------- ----------------------- ---------------- -------------------- ------------------- ------------
index1 col1, col2, col3, col4, col5 clustered, unique 0 0 0 Sep 21 2007 6:07PM Global Index
index2 col1, col2 nonclustered 0 0 0 Mar 18 2012 6:26AM Global Index 

• Can the 'update index statistics mytable' command be replaced with the following set of 'update statistics' commands?

update statistics mytable
update statistics mytable (col2)
update statistics mytable (col3)
update statistics mytable (col4)
update statistics mytable (col5) 

• SAP Adaptive Server Enterprise (ASE)  15.7
• SAP Adaptive Server Enterprise (ASE)  16.0

scan, sort, sampling, partial_hashing, hashing, histogram, gets , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem