Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?()
- A、ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)
- B、ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)
- C、EXEC sys.sp_configure 'fill factor (%)', '60'
- D、UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
正确答案:B
答案解析:有
微信扫一扫手机做题