I have oner large table and from time to time it' s overheaded. To fix it I run optimize command. But it doesn't help a lot - in some 5 minutes the table is overheaded again. Then I noticed that after some time it's not overheaded anymore (I didn't run optimize command).
My question is - what is the reason to optimize tables if overheaded tables after some time are not overheaded anymore even without optimizing?
