SAP Knowledge Base Article - Preview

2041442 - UPDATE STATISTICS on hyper-partitioned tables is very slow - SAP ASE

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.