SAP Knowledge Base Article - Preview

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


SAP Adaptive Server Enterprise 15.7


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.