I have a MongoDB with compound index by 4 fields and I want to reorder physical data distribution at HDD by this index. I am looking for something like creating chunk in NOT sharded environment.
Is any way to do this?
As workaround solution I can enumerate my collection by index and write it to another collection in this order. I didn't test it, but it should make sence.