Sample Header Ad - 728x90

Can an index be redefined prior to a rebuild?

0 votes
1 answer
62 views
Suppose that my server has a job that sometimes rebuilds indexes based on factors that I don't control (e.g. fragmentation). Suppose also that I am sure that it will one day rebuild an index that I'm interested in changing. Is there any way to instruct SQL Server that I want to change the WITH of an index upon its next rebuild, without rebuilding it right now? For example, suppose that PK_HugeTable is set to fill factor 25. On its next rebuild, I want to set it to 100. If I do not want to rebuild the index right now, what do I do? ALTER INDEX [...] SET works for some options, but not fill factor.
Asked by J. Mini (1237 rep)
Sep 22, 2024, 12:36 PM
Last activity: Sep 22, 2024, 01:52 PM