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 ONE Support launchpad (Login required).

Search for additional results

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