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

Table Partitioning

Posted on Jul 02, 2013 at 03:15 PM 31 Views

Hi All,

I need some help in understanding table partitioning. I need to know what are the various considerations (like data volumes, type of operations - insert, update, select etc) that need to be kept in while deciding upon the partitioning type, number of partitioning etc. Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Ravindra Channe
    Ravindra Channe
    Posted on Jul 04, 2013 at 05:47 AM
    2

    Hi Sanjay,

    The information on this topic is widely available on this forum. Rather than explaining it once again, I'd point you to the documents / links.

    Please refer to the document here to understand the concepts behind table partitioning.

    Some threads;

    http://scn.sap.com/thread/3334993

    http://scn.sap.com/thread/3171886

    This will help you understand partitioning better. If you have any more specific questions, please feel free to post it.

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

    • Ravindra Channe Former Member
      Jul 04, 2013 at 06:16 PM

      Hi Sanjay,

      If you understood the concepts, it will automatically answer your query. 😊

      As you might have understood, the partitioning depends upon the data volume. If your table is expected to contain data which can be logically partitioned on basis like time dimension, Geographical dimension etc, then depending upon the query pattern you can opt to partition the data based on these dimensions.

      If you have multiple nodes, then HANA automatically partitions the data and stores on multiple nodes, but an explicit partition always helps from the query performance perspective.

      No of partitions depend upon the grouping of the partition criteria.

      In short, there is no straight forward answer to your question, but the factors like data volume, what data is stored (possible partition criteria), Query pattern etc decide how the partitioning should be done.

      Regards,

      Ravi

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2013 at 04:25 PM
    0

    Hi All, any views on this ? Thanks.

    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.