2544057 - Question on placement of indexes in saparate or named cache - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2544057 - Question on placement of indexes in saparate or named cache - SAP ASE

Symptom

  • To either put the table and caches in different caches.
  • Or put (clustered index and table) in one cache and all non cluster indexes in another cache.
  • Or put all indexes (cluster and noncluster) in one cache and table in another cache.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

"named cache", "index cache", "index caches", spinlock contention, performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.