Forum Discussion
sql server rebuild index task problem
Hello everybody, sorry for my bad english please. I have sql server: 2019 (RTM-CU16) Indexes in my databases were very fragmented (60- 90 %) I created and executed rebuild index task: I...
Indexes in my databases were very fragmented (60- 90 %)
kastabeg , it's a relative factor, more important are the count of fragmented pages and if it's less then 1000 pages (=8 MB), you can completly ignore it.
Olaf
thank you, but as you can see at screenshot, i filtered small tables and "good " indexes.
problem is that my task rebuilds huge indexes with zero fragmentation when i start it second time.
problem is that my task rebuilds huge indexes with zero fragmentation when i start it second time.
Hi kastabeg
Please elaborate on how you got the conclusion that the index was rebuild for these small and fragmented tables. What exact query did you use or what source of info?
- thanks to everybody.
now i use https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
it works fine!
