Which of the following is a suggested threshold for performi

Which of the following is a suggested threshold for performing index fragmentation maintenance? a. update statistics for fragmentation more than 30 percent b. reorganize if the logical fragmentation is between 5 and 30 percent c. delete and recreate if the fragmentation is more than 10 percent d. rebuild if the fragmentation is less than 5 percent

Solution

Answer: reorganize if the logical fragmentation is between 5 and 30 percent

Below are the suggestion for performing index fragementation maintainencce:

Reorganize if the logical fragmentation is between 5 and 30 percent
Rebuild index if the logical fragementation is greater than 30 percent.

Update statistics for fragmentation is less than 5 ercent