SAP Knowledge Base Article - Preview

2913802 - CREATE INDEX is slow on hyper-partitioned tables - SAP BW on ASE

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.