Definition - What does
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.
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.
Advanced Business Application Programming (ABAP)
Advanced Business Application Programming Workbench (ABAP Workbench)
Structured Query Language (SQL)
SAP Help Portal: Pooled and Cluster Tables
- SAP Help Portal bundles access to SAP product documentation and also related information, such as SAP Notes, product availability information, as well as community content.
SAP Help Portal: Creating Table Pools/Table Clusters
Introduction to Databases
- No matter what part of IT you work in, you have to store data at one point or another, and it doesn't hurt for just about everybody to have some knowledge of databases and how they work.
Related White Papers
Recommended For You
INFOGRAPHIC: The World's 10 Largest Data Centers
Connect with us
Techopedia on Linkedin
Follow us on LinkedIn
Techopedia on Twitter
Sign up for Techopedia's Free Newsletter!
History of Tech
Who To Follow
Buzzwords and Jargon
World Wide Web