You administer a Microsoft SQL Server 2012 databasethat contains a table named OrderDetail. You discover
that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation.
You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?
A.
CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP
EXISTING
B.
ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
C.
ALTER INDEX ALL ON OrderDetail REBUILD
D.
ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms188388.aspx
I think the answer provided here is wrong as the index pointing to Table and Column name. which gives error message when you execute it.
The answer should be
ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail REORGANIZE
0
0
B
https://msdn.microsoft.com/en-us/library/ms189858.aspx
Rebuild Index can be done online/offline
Reorganizing Index is done online
Hence B
0
0
i tried it,akbar Ali is right,
the index pointing to table and column name is wrong,SqlServer will raise error about this:
Msg 1088, Level 16, State 9, Line 3
Cannot find the object “table.column” because it does not exist or you do not have permissions.
0
0