You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains a table named Orders. The
Orders table has several indexes and a very large number of rows. The database supports
an enterprise Web environment that is constantly used.
Thirty percent of the indexes on the Orders table is fragmented.
You need to defragment the indexes by ensuring that the effect on database availability is
minimized.
Which option should you include in the ALTER INDEX statement?
A.
Online
B.
Fill factor
C.
Pad index
D.
Sort in tempdb