question

kastabeg avatar image
kastabeg asked

sql server rebuild index task problem

Hello everybody, sorry fo my bad english please.

I have sql server: 2019 (RTM-CU15) (KB5008996)

Indexes in my databases were very fragmented (60- 90 %)

I created and executed rebuild index task:

безымянныи.png


Fragmentation of all indexes became ~ 0 %.

I executed rebuild index task again and it started rebuilding of all GOOD (0%) indexes in all tables again.

I don't understand why it's happening , fragmentation is about zero percent.

Thank you.

indexes
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.