Post reply

How to deliberately increase fragmentation?

  • March 9, 2016 at 10:01 am

    #325612

    I am debugging our defragmentation procedure, and I need to have higher fragmentation level for certain indexes. Is it possible to increase it somehow ?

    Thanks

  • March 9, 2016 at 10:09 am

    #1864061

    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,My blog: www.igormicev.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply