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.
ReplyDeleteAfter a long time, I read a very beautiful and very ismportant article that I enjoyed reading. I have found that this article has many important points, I sincerely thank the admin of this website for sharing it.Best replacement petrol caps service provider
ReplyDeleteThe information in the post you posted here is useful because it contains some of the best information available. Thanks for sharing it. Keep up the good work 3d Printing Nz
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHaving quality scan data ensures you don’t need to spend too much time during the post-processing phase, saving you time and headaches down the road. https://physicaldigital.com
ReplyDelete