I want to switch
AllowRowLocks=ON on a number of indexes. Some of those indexes are on large tables, and I don't really want to rebuild or reorganize the index.
It is not clear from the MSDN article whether or not the index will be rebuilt.
As a secondary related part of this question, the MSDN article states that the use of this is being phased out and shouldn't be used anymore:
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use ALTER INDEX (Transact-SQL).
Looking at the
ALTER INDEX, it seems you are forced to rebuild or reorganize. Have I understood that correctly? Through
ALTER INDEX can I just reset this row lock option?