Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Is Partitioning required in SAP HANA tables for one million records?
I think you are over thinking on a potential issue. The size of tables as you said will be rarely over one million records which does not qualify it to be considered a big table. In my application we have tables which are much bigger than that but still work pretty well over time. Also, as you said that data is mainly categorized on a daily basis so, theoretically it makes sense to partition tables on dates. It should improve the performance to some extent. But it can also lead to good number of partitions which can backfire too from maintenance point of view.
Also auditing your records will help your cause. What I would like you to first is start with normal tables without any partitioning at the start and observer performances for all sorts of queries. If you think that the performance is lagging, then you can go ahead with partitioning till that time just observe.
124 Views
