Large SAP tables which are good candidates for partitioning
Not all tables are good candidates for partitioning. The tool we have developed runs through multiple checks for large tables to identify the right candidate. Generally if the answer is yes to the following questions, table partitioning may be a suitable strategy for improving performance. 1. Is the database large enough? 2. Is the table large enough? 3. Do your reports and queries have distinguishable access patterns? 4. Are you experiencing slowness and performance degradation? 5. Is the skew factor for the data distribution under reasonable limits? Below are some of the large tables which have been candidates for table partitioning amongst our SAP customers. Large material master tables MARA Material Master Table MARC Plant Material Data MARO Company Material Data MAKT Material Text Table. MARCH Material Master C Segment: History MARD
This comment has been removed by the author.
ReplyDeleteYou can easily analyze the different facets of your business operations by customizing the data of your company with the help of Inetsoft dashboard software. Inetsoft
ReplyDeleteBest Learning Platform Thanks for sharing such informative content.
ReplyDeleteAPTRON's Machine Learning Training Institute in Gurgaon program covers many topics, including data analysis, statistical modeling, algorithms, and deep learning. The institute offers both classroom and online training options, so students can choose the format that works best for them. Additionally, the institute provides students with access to a range of resources and tools, including practice exercises, case studies, and real-world projects, to help them build their skills and gain practical experience.
ReplyDelete