Post reply

Modifying fillfactor without rebuilding the index

  • February 11, 2004 at 9:28 am

    #107266

    Hi,

    Is there any way to modify the fillfactor of an index without rebuilding it(DBCC DBREINDEX/dropping and recreating).

    Thanks in Advance.

     

    Regards

  • February 11, 2004 at 10:21 am

    #493681

    Unfortunately, You can't.

  • February 11, 2004 at 11:54 am

    #493693

    That really wouldn't make any sense.  Fill factor on an index is not maintained, it is a setting that only has any affect at the time an index is built/rebuilt.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • February 12, 2004 at 5:00 am

    #493773

    Thanks for your answers but this is what I have in mind :

     

    If I found out that the fillfactor for my index is not proper and the table/index is heavilly used; and I am in 24x7 environment. So if I drop and recreate the index in the middle of the operation the users go for a toss. So shouldn't there be a online way (opposed to the offline droping and recreating) to adjust the fillfactor?

     

    Regards.

  • February 12, 2004 at 7:22 am

    #493797

    "So if I drop and recreate the index in the middle of the operation the users go for a toss."

    Your create index command will be blocked if the index is being used by user transactions.

    The user activites will be blocked by recreating index statemnet until indexes are recreated.

  • February 12, 2004 at 1:09 pm

    #493881

    In Yukon there will be.


    Shamless self promotion - read my blog http://sirsql.net

  • February 13, 2004 at 7:58 am

    #493982

    Thank you all for your answers. I guess I will just have to wait for yukon then.

Viewing 7 posts - 1 through 6 (of 6 total)

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