In SQL 2000 while creating maintenance plan, there was Optimizations which REORGANIZED the data and indexes. What it does really? Does it reorganize all the indexes in the database?
No, it REBUILDS the indexes (in SQL2005+ terminology). The equivalent of REORGANIZE is DBCC INDEXDEFRAG and this cannot be done with a Maintenance Plan.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply