You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragment the indexes in an online manner. What command should you use?
A. DBCC DBREINDEX
B. DBCC INDEXDEFRAG
C. ALTER INDEX with the REORGANIZE option
D. ALTER INDEX with the LOB_COMPACTION option set to OFF
Answer:[C]
Highlight to find out the answer.
Saturday, July 24, 2010
Defragment indexes
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment