Index fragmentation and reorganizing database pages
- by TiQ
Say you have a database with heavy index fragmentation. Say this database also has a lot of free space due to frequent deletes in its data file. This free space is not contiguous.
If I rebuild all indexes to remove fragmentation and then reorganize the database pages so allocated pages and free pages are contiguous, would this cause further fragmentation in my indexes?
I guess the question can be posed as: if it matters, which should I do first, reorganize or rebuild?