count of index is increased after Index reorganizing

Question

Hi,

I have findout the indexes from one database having fragmentation is less than 30 & greater than 5 using sys.dm_db_index_physical_stats

dmv. Now I want to reorganize that all indexes for that I have created a script which will automatically reorganzise the indexes having avg.fragmentation is less than 30 & greater than 5.  However  I found that after reorganizing activity count of indexes is increased.  does reorganizing increase indexes? or before & after count of indexes should be same?

Answer 1

Hi Mayur,

Reorganizing does not create new indexes or drop indexes.

If you want to implement the automatic job for controlling fragmentation, the Ola Hallengren's Solution is bet free tool for this..

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

---

- Chintak (My Blog)