What should you set from the index options?

You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that many page splits occur when records are inserted or updated in the table.
You need to minimize the number of page splits.
What should you set from the index options?

You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that many page splits occur when records are inserted or updated in the table.
You need to minimize the number of page splits.
What should you set from the index options?

A.
FILLFACTOR = 0

B.
STATISTICS_NORECOMPUTE = OFF

C.
STATISTICS_NORECOMPUTE = ON

D.
FILLFACTOR = 80

Explanation:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/ms177459.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *