Hello,
There is a batch called /Database index rebuild system job/, as far as I know, it checks the table defragmentations and rebuilds the indexes. The class name is /SysDatabaseIndexRebuildTask/. When I run this batch, it completes in 15 seconds without doing anything. Do I need a special parameter for this to work. When I examined the code, I saw that it uses the SYSFLIGHTING structure, but I could not find a complete solution. Microsoft said that it disable this batch on January 28, 2021. said that it now does the index management itself. However, when I look at it, I see that fragmentation rates are very high. Your ideas are very important, thank you.
There is a batch called /Database index rebuild system job/, as far as I know, it checks the table defragmentations and rebuilds the indexes. The class name is /SysDatabaseIndexRebuildTask/. When I run this batch, it completes in 15 seconds without doing anything. Do I need a special parameter for this to work. When I examined the code, I saw that it uses the SYSFLIGHTING structure, but I could not find a complete solution. Microsoft said that it disable this batch on January 28, 2021. said that it now does the index management itself. However, when I look at it, I see that fragmentation rates are very high. Your ideas are very important, thank you.
291,280
