I am debugging our defragmentation procedure, and I need to have higher fragmentation level for certain indexes. Is it possible to increase it somehow ?
Do ALTER one column of the table, e.g. extend it from int to bigint, and you'll have the fragmentation changed significantly. This is a way without changing data.
Otherwise do a significant portion of update in the table.
Consider the constraints.
Igor Micev
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply