Need to make changes to MaxMrgOutROSSizeMB, for this to take effect the table needs to be rebalanced, but the "workload analyzer" has also suggested that the table is reorganized.
What is the difference between the 2 commands, will both a rebalance and reorganize need to be run?
Tim
Question
Difference between rebalance and reorganize of a table
+1
+2A "rebalance" moves data across nodes to match segmentation clause.
A "reorganization" moves data to different partitions on the same node to match partition clause.
I think only "rebalance" is necessary in this case since there's no need to move data between nodes or between partitions, you just need to trigger TM to split containers once. A quick way to verify would be to pick a table with a few very large containers and run REBALANCE_TABLE on that table, then check storage_containers system table to verify whether the ROS files were split.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
