Skip to Content
author's profile photo Aniruddha Shinde
0
Aniruddha Shinde

Data Partitioning Strategy

Posted on Sep 14, 2016 at 05:45 AM 189 Views

Hi

I have scenario here , i have 3 tables and i am anticipating they are going to grow in large size possibly over 2 billion records in future.

The application using these tables is yet to be deployed , i am looking here strategy for partitioning the table.

Do i create partition for these tables after the application is deployed for production and seeing the growth rate of table data ( monitoring some threshold limit of no of records which i am not aware of now) or do i design partitions for tables in schema before i deploy this into production?

If i have to partition can i partition on Range partitioning on timestamp column, ? on month or on year vale of timestamp?

many thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2016 at 12:55 PM
    3

    Hi Aniruddha

    You can partition on date range. See the link below

    Using Date Functions to Partition - SAP HANA Administration Guide - SAP Library

    As to when you create the partition, I would think it will be far easier to create the partitions now rather than wait for the tables to fill up

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

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.