Projection Segmentation after a delete
I executed a delete statement using Primary key and the projection is segmented on the same PK. The delete could cause a data skew.
Is there a way to rehash() the projection on the segmentation clause to fix the skew. From the documentation I don't think mergeout or purge() will do it.
0
Answers
The hash is based on the value of field that you use, if you drop simnifically a specific value, you could have skewed data but the data will still skew if you keep the same value. The only way to resolve is to change the fields used for the segmentation or add an other field.
HTH