Modifying fillfactor without rebuilding the index

Question

Post reply

Modifying fillfactor without rebuilding the index

Xearo

SSC-Addicted

Points: 438
More actions
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

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

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

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Allen Cui-55137

SSC Guru

Points: 51650

February 11, 2004 at 10:21 am

#493681

Unfortunately, You can't.

DCPeterson SSCoach Points: 15256 More actions · Answer 2

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

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

Xearo SSC-Addicted Points: 438 More actions · Answer 3

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.