Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

when to use cluster table

Former Member
0 Kudos

when we will use the cluster table.. in which situation we will declare the table type as cluster table.

thanks and regards


Message was edited by: suresh m


Former Member
0 Kudos

hi suresh,

Cluster table are logical tables that must be assigned to a table cluster when they are defined.

Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

below link can help u



Message was edited by: Venu Narayana

Former Member
0 Kudos

Hi Suresh,

Please revisit your past threads and see the replies that you have got. The answers that were given along with the content in the links provided should help you decide when the table should be a cluster table.

Also, please do reward points to the answers that were given to your questions.


Anand Mandalika.

Former Member
0 Kudos

It's my understanding that cluster tables were developed by SAP to get around an early Oracle limit on the number of fields allowed on their tables. That limit is no more and there is no need to define a table as a cluster.


Former Member
0 Kudos


A cluster is advantageous in the case where data is accessed from multiple tables simultaneously and those tables have at least one of their primary key fields in common. Cluster tables reduce the number of database reads and thereby improve performance.

Several logical data records from different cluster tables can be stored together in one physical record in a table cluster

Check the below links for further info:



0 Kudos

Hi suresh,

User is not going to deal with these cluster tables. For all cluster tables there is one cluster pool. Cluster tables are similar to pool tables. The difference between the cluster and pool table is that in cluster table , primary key is taken as reference. For all cluster tables there is unique identifier to cluster pool.

For more info

with regards…