Symptom
- Index creation on hyper-partitioned tables (> 1000 partitions) is very slow.
- ASE parallelism is configured and parallel worker processes are being correctly used for the CREATE INDEX.
- The stacktrace for the slow CREATE INDEX 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()
cri_write_sortstats()
cri_physbuild()
cri_bldindex()
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Business Warehouse - All versions
- SAP Solution Manager
Keywords
"CREATE INDEX", partitions, partitioned, hyper-partitioned, "number of histogram steps", Infocube, fact table , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , How To
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.