Skip to Content
author's profile photo Former Member
Former Member

Cluster Table

why do we need cluster table??how efficient is it in application if created??

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 10:44 AM

    Hi,

    Table Clusters generally contain the data from a samll number of very large tables.

    i.e. say there are 4 cluster tables each having 1,00,000 records.

    In that case we can create a table cluster which will be having all the records from all the 4 tables.

    Here the mandat is that all the cluster tables must have at least one key in common.

    Actually, this all is done for database management.

    Generally cluster tables contain the sustem information.

    e.g. Change history tables CDHDR and CDPOS are cluster tables.

    Moreover, u also cannot put a join on cluster tables.

    Regards

    Himanshu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2007 at 10:43 AM

    Check the link -

    cluster-table

    Regards,

    Amit

    reward all helpful replies.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 10:43 AM

    Hi Suma,

    <b>Cluster Table</b> : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation

    A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.

    <b>For more refer to this link.</b>

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

    <b>Reward points if it solves ur query or answer is helpful</b>

    Thanks

    Chinmay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.