Symptom
- UPDATE STATISTICS on tables with high number of partitions (over 1000) is very slow.
- Individual partitions can have update statistics run very quickly but the time for the update statistics at the table level far exceeds the sum of the times for each partition.
- The stacktrace for the slow UPDATE STATISTICS spid references the following functions --
In isql:
dbcc traceon (3604)
go
dbcc stacktrace (<CREATE INDEX spid> retrieved via sp_who or DBACockpit->Process Monitor)
go
stm_process_step()
stio_merge_col_list()
stio_mergepartitions()
stio_write_global_stats()
sysstatistics_write()
stat_write()
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 fro Business Warehouse
- SAP Business Warehouse - All versions
Product
SAP Adaptive Server Enterprise 15.7
Keywords
"histogram steps", "update statistics", statistics, partitions, CR 764508, 764508, CR 755103, 755013 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed
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.