SAP Knowledge Base Article - Preview

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

Symptom

  • The tempdb database gets 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 statisctics' commands ?

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


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)  15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

scan, sort, sampling, partial_hashing, hashing, histogram , 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 ONE Support launchpad (Login required).

Search for additional results

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