Which of the following is a suggested threshold for performing index fragmentation maintenance?
A)delete and recreate if the fragmentation is more than 10 percent
B)update statistics for fragmentation more than 30 percent
C)rebuild if the fragmentation is less than 5 percent
D)reorganize if the logical fragmentation is between 5 and 30 percent

Question

Quizplus · Accepted Answer

A common threshold for performing index fragmentation maintenance is to reorganize if the logical fragmentation is between 5 and 30 percent. This helps to improve performance without completely rebuilding the index. However, if the fragmentation is higher than 30 percent, it may be necessary to rebuild the index. Deleting and recreating an index should only be done in very specific scenarios and is not a recommended regular maintenance task. Updating statistics can help improve query performance, but it is not directly related to index fragmentation maintenance. Rebuilding an index with less than 5 percent fragmentation may not provide any significant performance improvements.

Which of the Following Is a Suggested Threshold for Performing