[WEBINAR] Bulletproof: How Today's Business Leaders Stay on Top

Cluster Table

Definition - What does Cluster Table mean?

Cluster tables are special types of tables present in the SAP data dictionary. They are logical tables maintained as records of the normal SAP tables, which are commonly known as transparent tables. A key advantage of using cluster tables is that data is stored in a compressed format, reducing memory space and the landscape network load for retrieving information from these tables.

Techopedia explains Cluster Table

With cluster tables, functionally dependent data is distributed over many tables and grouped under one cluster table. The key fields in these tables are stored as key fields of cluster tables.

Prominent features of cluster tables are as follows:
  • Native SQL cannot be used on these tables.
  • They cannot be directly managed by database system tools.
  • Administration of cluster tables is easier because the tables are not created separately, like transparent tables in a database.
  • Functionally dependent data stored in cluster tables may be read together, thus reducing access to the database.
  • Like pool tables, indexes for non-key fields cannot be created. However, primary or other indexes can be created for a set of fields that are to be key fields.
  • Database views, join statements or append statements cannot be used on these tables.
This definition was written in the context of SAP
Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.