February 8, 2017 at 1:39 pm
Some of Indexes on table are 99% Fragmented.. is this a reason for me too worry about?
does shrinking the database cause indexes to defragment? also when re-organizing the indexes, do you needs to be out of the system
February 8, 2017 at 2:37 pm
Please see replies below -
Some of Indexes on table are 99% Fragmented.. is this a reason for me too worry about?
A matter of opinion, but, if the number of pages for the index is under 1000, it is generally a non-issue. Anything above this, should be addressed.
Does shrinking the database cause indexes to defragment?
Pages are moved from the end of the database file to the first free page and therefore the order of the pages will be reversed and this causes a high fragmentation on the (clustered) indexes.
Yes, it is recommended to either reorg or rebuild all indexes following a shinkage.
Also when re-organizing the indexes, do you need to be out of the system?
No, if you reorg, users can be connected and the chance of blocking is very rare or never.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply