User-939850651 posted
Hi saffy,
For few tables index fragmentation increase to 95% with in hour after index rebuild.
Have you turned on auto_shrink?
The data file shrinkage leads to the complete fragmentation of the index, and the efficiency of the index is greatly reduced, which seriously affects the performance. And it also generates a lot of I/O operations, consumes a lot of CPU resources, and will
cause performance degradation.
Here is a good article:
Why you should not shrink your data files
If I misunderstood anything, could you provide more details?
Best regards,
Xudong Peng