You are the database administrator for AIOTestKing.com. The company uses a database that contains a table named Sales. The CREATE statement for the Sales table is shown in the exhibit.
The Sales table is very write-intensive and is commonly used in queries. Both of the indexes on the Sales table become fragmented within the first two hours of being rebuilt.
Both leaf and intermediate level pages split frequently. There is sufficient disk space available to fully optimize the indexes. You need to optimize the nonclustered index on the Sales_Amount column of the Sales table. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Set the FILLFACTOR option to 100 when rebuilding the index.
B.
Set the FILLFACTOR option to 70 when rebuilding the index.
C.
Set the PAD_INDEX option to OFF when building the index.
D.
Set the PAD_INDEX option to ON when building the index.
Explanation:
FILLFACTOR specifies a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild. PAD_INDEX = ON specifies that the percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index.