Question: 18
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.Pad index
B.Sort in tempdb
C.Fill factor
D.Online
Answer : D
No comments:
Post a Comment
Note: only a member of this blog may post a comment.