Your database is 5GB and contains a table named SalesHistory. Sales information is frequently inserted and updated.
You discover that excessive page splitting is occurring.
You need to reduce the occurrence of page splitting in the SalesHistory table.
Which code segment should you use?.
A.
ALTER DATABASE Sales MODIFY FILE
(NAME = Salesdat3, SIZE = 10GB);
B.
ALTER INDEX ALL ON Sales.SalesHistory REBUILD WITH (FILLFACTOR = 60);
C.
EXEC sys.sp_configure ‘fill factor (%)’, ’60’;
D.
UPDATE STATISTICS Sales.SalesHistory(Products)
WITH FULLSCAN, NORECOMPUTE;
B