How to configure Spotlight to generate a rebuild indexes script using the online option? (4229671)

Chat now with support

Return

Title

How to configure Spotlight to generate a rebuild indexes script using the online option?
Description

Is it possible to have the "Generate Defragmentation Script" option to generate code that allows the option to perform index operations online? Looking for Spotlight to generate the following as an example:
USE AdventureWorks2012;
GO
ALTER INDEX AK_Employee_NationalIDNumber ON HumanResources.Employee
REBUILD WITH (ONLINE = ON);
GO
It would be nice to have an option to turn that feature on or off when generating the script to rebuild the indexes.

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.