index Fragmentation increase with in hour for some tables.

Question

User779033375 posted

Hello Team,

For few tables index fragmentation increase to 95% with in hour after index rebuild.

Can you please suggest.

Answer 1

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

Answer 2

User779033375 posted

Auto shrink is off. Any other possibilities?