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
Last activity: Sep 22, 2024, 01:52 PM